Day counter function

Kashmira Kulkarni

Hello,

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

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?

Kashmira Kulkarni

@KDM thank you!

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

Thanks once again!