ExcelBanter - Account for Public Holidays

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Account for Public Holidays (https://www.excelbanter.com/excel-discussion-misc-queries/15643-account-public-holidays.html)

POM

Account for Public Holidays

Hi All -

I need to calculate for the last 10 years the number of Tuesdays in each
month that did not immediately follow an English public holiday, and the
number of Wednesdays in each month that came 2 days after a public holiday.
Any ideas (apart from manually looking them up!)

Thanks

All times are GMT +1. The time now is 04:15 PM.