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.