Day counter function


I am trying to set up a day counter eg from day of arrival to today. I set up the formula =NETDAYS([Delivery Date]@row, TODAY()), but I keep getting #invalid data type. What do I need to change?


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Kashmira Kulkarni

    Please verify that the column that you're placing the formula in is a Text/Number column. This formula will return a number so you cannot be in a date column. Also, if your [Delivery Date] does not contain a date, you'll receive the error. You could set up a check to validate the [Delivery Date].

    =If ISDATE([Delivery Date]@row, NETDAYS([Delivery Date]@row, TODAY()))

    Do either of these suggestions solve your issue?

  • @KDM thank you!

    My delivery date column was set to Text/Number, changed it to Date and it worked.

    Thanks once again!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!