Formula to Calculate the Number of Work Days a Task Took
Options
Good morning,
I am trying to figure out the number of work days between the actual start and finish dates.
The formula =Finish@row  Start@row is giving me the total number of days.
Example:
Start date = 03/07/2022
Finish date = 03/31/2022, the answer is 24. Whereas the workdays would be less.
The formula =WORKDAY(Finish@row  Start@row) returns an INCORRECT ARGUMENT SET.
Thank you for your help!
Best Answer

=networkdays(start@row,finish@row)
Answers

you're close but you needed to use =NETWORKDAYS

@Michael Culley Thank you, but I still get Incorrect Argument Set

=networkdays(start@row,finish@row)

@Michael Culley Thank you so much! That worked!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!