Perpetual calendar template Excel : here is a free and unique dynamic time frame to download with one simple click. This document includes a Federal Holidays calculator.
Excel is an amazing software that allows very interesting things like making a perpetual calendar, that means a time frame which is updated whatever the year selected.
If you wonder how to make this type of calendar using basic Excel functions such as WEEKDAY and VLOOKUP, this document is made for you. This dynamic time frame also takes into account leap years.
In addition, this time frame includes an automatic calculation of the 11 US federal holidays which are :
- New Year’s Day: January the 1st
- Martin Luther King’s Day: 3rd Monday in January
- President’s Day: 3rd Monday in February
- Memorial Day: last Monday in May
- Juneteenth: June the 19th
- Independence Day: July the 4th
- Labor Day: 1st Monday in September
- Columbus Day: 2nd Monday in October
- Veterans’ Day: November the 11th
- Thanksgiving Day: 4th Thursday in November
- Christmas Day: December the 25th
Look at the cells: smart Excel formulas help position varying federal holidays on the time frame. You will certainly learn a lot about entering an holiday formula in Excel!
This perpetual monthly calendar is editable and printable. You can use it as a day-to-day work document. It is ideally suited for managing daily life, note birthdays, appointments and things to think about.
Refer to this perpetual calendar table to anticipate or find the day of the week corresponding to any date in a specific year. Find out whether a date is a federal holiday or not.
Ready to download our perpetual calendar template Excel?
Perpetual calendar template Excel : download it now!
Click on the link below to download your free perpetual calendar template on Excel:
Here is an image of the document to download :
Free perpetual calendar template Excel: how does it work?
This free perpetual calendar template is easy to use. No Excel skills needed: all you have to do is enter the year you want in the first blue cell at the top left and the time frame will update automatically.
The document only works with formulas : there are no Excel macros, which makes it more secure. The spreadsheets are protected with a password to avoid any issue. You can get the password by clicking on the link in the last sheet of the workbook.
Now, let’s play! In the second spreasheet, you can:
- enter a specific date to see which day of the week it falls,
- find out what day of the week you were born -simply enter your date of birth,
- the number of days you have lived until today. It works with the TODAY() function. Be careful, the result could scare you!
Finally, in the last spreadsheet you will find the link to get the password of the document, to be used only if you master Excel.
Download other day-to-day Excel documents for free.
Now you know how to make an holiday calendar in Excel, you have to know that we have created other Excel documents useful for everyday life, to use at home, at work or at school.
Here are some examples: