Function for finding the # of days between two dates

VaneT

Hello,

I am trying to find a function in Smartsheet that will allow me to identify the number of days between two dates. In excel, this function would be DAYS(end_date, start_date), but I can't seem to find a similar function in Smartsheet.

Suggestions?

Thank you

Mike Wilday

There are three different functions you can use. One uses calendar days and the other two uses work days. But networkday adds and additional day if the start date is on a non-workday.

https://help.smartsheet.com/function/netdays

https://help.smartsheet.com/function/networkdays

https://help.smartsheet.com/function/networkday

I hope that helps!!!

Peggy Parchert

Hello @VaneT

Try this:

=NETDAYS([Start Date]@row, [End Date]@row)

Hope this helps.

Peggy

Norberto

Interestingly enough, when I use today - yesterday I get the #2
12/05/2024 - 12/04/2024…

Does that mean its counting total days as in th 5th and 4th?

Mike Wilday

Yes, if you only want to count workdays you should use =NETWORKDAYS(start_date, end_date, [holidays]) the third parameter is optional if you want to account for non-working holidays.

Unknown

This content has been removed.

1994EJH

I have tried using this formula but its not working. I'm getting a result of '#INVALID DATA TYPE'.

I'm trying to see how many days are between the created date and modified date.

The dates I'm looking at are formulas, is this the problem?

Thank you!

Mike Wilday

Should work. an Invalid data type error is usually because what is landing in the column doesn't match the column type. Check your column type to ensure it is a text/type column.