Adjust my Formula to show tasks that start the following week

[Will Shaw]

Hi, I am trying to amend my formula to show all tasks that are due to start the following week from the status date.

This formula is currently for tasks that are finishing in 7 days from the status date.

IIf([% Complete]<100,IIf(DateValue([Finish])<(DateValue([Status Date])+1),”0″,IIf(DateValue([Finish])>(DateValue([Status Date])+7),”0″,”1″)),”0″).

Help is greatly appreciated.

[Ismet Kocaman]

Instead of a formula, I would apply a custom group to Start column to group the start dates on weekly basis, starting from the status date. Anyway, the following formula may work (tasks scheduled to start between [Status Date] + 1 and [Status Date] + 7,exclusive):

Using a task custom flag field:

iif( [% Complete] < 100 AND
(
DateValue([Start]) > DateValue([Status Date] + 1) AND
DateValue([Start]) < DateValue([Status Date] + 7)
),
Yes, No )

[Author]

Posts