I’m trying to make a schedule view of the current jobs of the week and who is assigned to where on what day.
I currently use for example (Monday):
=IF(WEEKDAY([Clean Date])=2, [_Cleaners - Clean] , IF(WEEKDAY([Repair Date])=2, [_Repairers - Repair], IF(WEEKDAY([Paint Date])=2, [_Painters - Paint]," ")))
but how would I write it if I only wanted it to show this current week and not every other week as well overlapping?
I will attach a photo of what it is currently showing.