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

How do I calculate future date after number of days 1
Future date with six day week including holidays 1
Ok how about this formula using days :-/ 1
Calculate the number of days to exclude Sunday & Holidays 6
Difference - except for Saturdays and Sundays 10
Calculating 10 Business Days from the Last Business Day of the Mon 5
UK Business Days Formula 1
Exclude weekends when counting days only on day 29 or 30 3

Top