Workday Calculation...

[ifrydr]

Hello -

I am trying to find the correct way to add 5 workdays to a date that will be entered by a user in another cell.

Any help would be appreciated.

Thanks!

 

[T. Valko]

Hello -

I am trying to find the correct way to add 5 workdays to a date that will be entered by a user in another cell.

Any help would be appreciated.

Thanks!

Use the WORKDAY function...

A1 = some date
B1 = 5

=WORKDAY(A1,B1,holidays)

Holidays is an optional argument that let's you list dates to be excluded from the calculation. Holidays is typically a range reference like C1:C10.

Note that the WORKDAY function requires the Analysis ToolPak add-in be
installed if you're using a version of Excel prior to Excel 2007. If you enter the formula and get a #NAME? error look in Excel help for the WORKDAY function. It'll tell you how to fix the problem.

 

[ifrydr]

Thank you!

 

[T. Valko]

Thank you!

You're welcome!