Formula to determine 10 business days

O

OfficeManager

Can anyone help me with a formula to determine a date that will be 10
business days from today's date? I am working on a form and I would like
have a cell determine the due date of the product. No only do I need to
eliminate all Saturdays and Sundays, but is it possible also to eliminate all
national holidays in the formula?

Any help would be much appreciated.
TIA
 
M

Mike H

Hi,

Select enough cells in a column somewhere that provides enough cells to
allow you to enter the dates of your public holidays and then

Insert|Name Define and call it holidays.
Enter you holiday dates in this range.
use the formula

=WORKDAY(TODAY(),10,Holidays)

Mike
 
G

Gord Dibben

See help on WORKDAY function from the Analysis Toolpak.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Accessibilty - how to open doc with keyboard? 0
Trying to remove error from conflicting code 0
How do I calculate future date after number of days 1
End Date/Time adding business hours 1
Future date with six day week including holidays 1
Calculating days spent to complete a task 2
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Auto add holidays to monthly Publisher 2016 calendar 0

Top