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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!