How to Create Excel Calendar for Specific Year with Automatic Date Marker

This video will show you how to create excel calendar for specific year with automatic date marker that you can modify every year. It uses year 2016 as its year reference.

You can find written tutorial in exceltemplate.net/tutorial/how-to-create-year-a…

Basically, this excel tutorial will show you how to create it from a blank worksheet. It will be divided into several group steps :
1. Create month of January table
2. Duplicate and modify January table to remaining months, February to December
3. Create single date event tables, remember to group date column and give a name to it
4. Select all 12 month calendar tables and create conditional formatting that will change date colors if the dates are the same with dates in that date column
5. Create period date event tables, remember to give a name to each date cells
6. Select all 12 month calendar tables and create conditional formatting that will change date colors if the dates are within the date period
7. Personalize the calendar
8. Prepare for printing
9. Finished.

You can design other calendars and apply this method to your calendar. You can visit our website to see other models that are built based on this method.