# Elapsed Days Counter - How?

Options
edited 12/09/19

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

• ✭✭
Options

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)

• Options

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.

• Options

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.

• Options

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

• ✭✭✭✭✭
Options

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.

• ✭✭✭
Options

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.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!