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!