Formula to determine 10 business days
 

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

Formula to determine 10 business days
 

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

"OfficeManager" wrote:

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

Formula to determine 10 business days
 

See help on WORKDAY function from the Analysis Toolpak.


Gord Dibben MS Excel MVP

On Tue, 2 Sep 2008 12:12:01 -0700, OfficeManager
wrote:

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