Hi. I have an MSP task calendar that reflects that those working to that calendar have every other Friday off.
I would like to create a filter that will highlight which tasks are affected by these Fridays. This seems to be defined as "what tasks have a start date before the off-Fridays and end after the off-Fridays". This calendar causes work on the task to stop on end of day Thursday and resume on Monday.
If it helps and is not on a bad or inefficient track, I have been able to identify tasks that Start on the off-Fridays by picking one and calculating each 2 weeks forward with this flag:
(Fix([Start])-DateValue("5/9/14")) Mod 14=0
I have been unable to figure out so far how to identify those tasks that are ongoing across an off-Friday. Any help is greatly appreciated. Thanks!