Accounting for HOLIDAYS

[AccentureTony]

Hello all,

Is there a formula I can plug in to a populated list of dates tha
automatically accounts for American holidays?

Thanks for your help

 

[Frank Kabel]

Hi
you can use WORKDAY for this. BUT you have to enter your holiday dates
in a separate range

 

[Norman Harker]

Hi AccentureTony!

WORKDAYS is the function you need. For formulas that calculate
holidays see:

Chip Pearson:
http://www.cpearson.com/excel/holidays.htm

But holidays and replacement holidays where fixed dates occur on
weekends vary from State to State so make sure you check carefully
especially as Christmas and Boxing Day 2004 are Saturday and Sunday
and New Years Day 2005 is a Saturday.