Skip to content
ProjectControls.com
Microsoft Project

Filter or highlight tasks that are ongoing during task calendar exceptions (every other Friday off)

In the Open Standard
Pat OMember for 12 years 5 months
Created
2
6
0

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!

Save Follow Follow forum Report
Reply New topic

2 replies

Oldest first
  1. 0
    Pat O ·
    #1

    Got something working that

    Got something working that seems more brute force than elegant, but it gets me there:

    1. Find the first and second Fridays following the start of a task. 
    2. Test to see which of those Fridays is an off Friday.
    3. Test to see if the task is not yet finished by the off Friday.
    4. Also flag tasks starting the Monday after an off Friday.
    Report
  2. 0
    Pat O ·
    #2

    Not sure why my posts are

    Not sure why my posts are doubling up - this was a dup.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?