How do I calculate the dates of holidays in Excel?

M

Myrna Larson

To produce the list of holidays? No. They vary from one country to another. In
general, if you want to use the WORKDAY and NETWORKDAYS functions with a
holiday list, you create that yourself, manually.

That said, I have posted code in the past to generate a list of the 11 US
holidays that were observed in the state of Wisconsin. If you search Google
for MakeHolidays, you should find it.
 
M

Myrna Larson

Correction: search the newsgroups for MakeHolidayList. I posted the code in
1999.
 
Top