Holiday lists

Occasional Visitor

Hi, Does anyone know if it is possible to automatically put national holidays into excel when creating

 sheets for separate months of the year ?


2 Replies


National holidays? from which country?

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

* Knowing the Excel version and operating system would also be an advantage.


Nevertheless, here is some information


Excel calendar templates

An Excel calendar template may have one or more of features


you find here many Templates


I would be happy to know if I could help.



I know I don't know anything (Socrates)


* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

Hello, for a list of national holidays for US and Canada, for years 2020-2050, please see
Regards from Baltimore.