Calculate number of days a task is later than forecast end date

Dan Harris

Hi,

Can somebody help?

I need to add a column that calculates how many days late tasks less than 100% complete are compared to today see below example, basically need a formula that calculates the 'working days late' column.

Thanks

forecast end date % Complete working days late (based on todays date)

3/8/20 99% 2

Mathieu PERSICO

Hi Dan,

Try this formula in your [Complete working days late] column,

=IF([date %]@row < 1, TODAY() - [forecast end]@row, "-")

Hope this helps,