Formula to Calculate the Number of Work Days a Task Took
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 34 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!