How do I calculate the dates of holidays in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Are there Excel functions or formulas that calculate the dates of holidays?
 
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.
 
Correction: search the newsgroups for MakeHolidayList. I posted the code in
1999.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating dates to include Saturdays but not Sundays 1
Calculate Project dates 2
Past Date Calculation 2
In WORKDAY function, how to exclude multiple/variable holiday rang 4
Calculation between 2 date? 3
QUESTION REGARDING HOLIDAYS 8
Calculate times between dates and times in Excel 1
Calculate a future date, not including Sat/Sun or Bank Holidays 3

Back
Top