Elapsed Days Counter - How?


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
    StacyDe ✭✭

    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)

  • 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

    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

    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?



  • Katye Reed
    Katye Reed ✭✭✭✭✭

    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
    topazfae ✭✭✭

    @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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!