Elapsed Days Counter - How?

Needing some Help · 05/07/18

Hi everyone,

I'm needing to report on elapsed days for a few tasks. Anyone know how to do this?

Note - this is different from the 'duration' function that already exists in the Gannt view. That is where I have a start and end date. In this example, I have a start date, but no end date quite yet.

Any help is greatly appreciated!

Thanks

StacyDe · 05/07/18

Heres an example of how to see "how many days has it been since the start of this task"... if the start date is in row 3:

=SUM(TODAY() - [Start Date]3)

darelcragnolin32946 · 05/07/18

If you only want to count working days, you can also use the NETWORKDAYS function, taking the difference between your start date and a TODAY reference. This function can also reference specific holidays so that they aren't counted.

bdchapin · 05/07/18

Something like this?

=NETWORKDAY(Start1, IF(ISBLANK(Finish1), TODAY(), Finish1))

This will count the workdays between start and finish and use today's date if the task has not completed.

J McMahon · 09/24/18

Hello StacyDe,

Thank you for your comment. I am trying to do the same thing, and I keep coming up with at error (#DATE EXPECTED) when I use your formula. Any clue as to what I'm doing wrong?

Thanks,

John

Katye Reed · 05/29/19

Thank you, I found this formula to be extremely helpful as another way to track at risk tasks and trigger a prioritization review by the appropriate personnel.

topazfae · 06/23/23

@Needing some Help

I know this is old post - but to answer your question - you can do this following formula (they added new formula ot make it easier).

Reason why you got the error - #Date expected because you set the column to date. You need to change it to text/number. They expect the result to be date but the result came out as a number which conflict with the column's type.

What I did was

=SUM([End Date]@row - [Start Date]@row)

It gives me the number of days lapsed - Start date is on May 11, 23 and the end date is May 14, 23, it will give me 3.

Elapsed Days Counter - How?

Comments

Help Article Resources

Categories