Calculating Days

Jacob Judd

Hello

How do i get this formula to Calculating the numbers of Days when i select the date columns.

e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.

Mike Wilday

Do you want workdays or calendar days? 

Work Days =networkdays([Date Column 1]24, [Date Column 2]24)

Calendar Days =netdays([Date Column 1]24, [Date Column 2]24)

replace the Date Column 1 and Date Column 2 with the actual column name. 24 assumes this is row 24. 

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

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

Enjoy.