Count days between start date and today


I want to count the days between the start date and today if the end date is blank.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    If you want to count from start to end if there is an end but use today if there is no end, then it would look something like this...

    =IF(ISDATE([End Date]@row), [End Date]@row, TODAY()) - [Start Date]@row

    If you want to leave blank when an end date is present and only count when end date is blank...

    =IF([End Date]@row = "", TODAY() - [Start Date]@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!