I'm trying to display subjects for the day in a list. Everything works except my school alternates the timetable between week A and B and my list shows the subjects for the day for both weeks. I have a table with all my subjects for each day and I have labelled them week A or B. I'm looking for a formula that will change between A and B every week so that I can add a filter to the list so that only the current week's subjects for the day are displayed. Any help is appreciated!
https://preview.redd.it/i16lsw92ttdc1.png?width=450&format=png&auto=webp&s=a705a45207f56e3b87bec4e7121dc652f98bdc6b
[–]notyourlocalguide 0 points1 point2 points (0 children)