Accounting for HOLIDAYS

  • Thread starter Thread starter AccentureTony
  • Start date Start date
A

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
 
Hi
you can use WORKDAY for this. BUT you have to enter your holiday dates
in a separate range
 
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.
 
Back
Top