Elapsed Days Counter - How?

Needing some Help
Needing some Help โœญโœญ
edited 12/09/19 in Formulas and Functions

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 :)

Comments

  • 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)

  • darelcragnolin32946
    darelcragnolin32946 โœญโœญ

    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
    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
    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?

    Thanks,

    John

  • 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!