Formula to determine 10 business days

  • Thread starter Thread starter OfficeManager
  • Start date Start date
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
 
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
 
See help on WORKDAY function from the Analysis Toolpak.


Gord Dibben MS Excel MVP
 
Back
Top