I want to set up a rolling 2 week look ahead filter in MS Project. I know how to add 14 days to today using now() + 14 however it would be better if it use the date of the Friday in 2 weeks time. Hence if I was to run it today (10th June) it would show tasks which started before Friday 28th June. I would also show the same tasks if I was to run it on the 11th, 12th … 14th. This has two advantages – 1) it fits with how the business people think and 2) it allows me to run the report at any time.

I know I can set a filter which asks for a date but it would be nice if it did some of the thinking for the user.

I would prefer to avoid VBA if at all possible.

Thanks

Miles