Networkdays formula with result as a date

Options
Pamella Souza
Pamella Souza ✭✭
edited 04/06/23 in Formulas and Functions

I have a formula that calculates the number of business days between two dates and gives me the result in days.

Now I need the same thing, but I need the result as a date.


Here is the formula I am using for the duration in days:

=IFERROR(NETWORKDAYS([START DATE]6, [END DATE]6), 0)


Can someone help me figure out how I can get the result as a date, please?


Thanks,

Pamella.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!