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.
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.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
©2022. All Rights Reserved Smartsheet Inc.