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