These 2014 Calendars require, at least, Microsoft Excel 2007 to make all the excel formulas running well. In this version, you can mark consecutive dates, for example, exhibition events, in your calendar by typing the start and end dates of your events. There 6 different color markers you can use, 3 markers for single dates category and 3 others for consecutive dates category.
There are 3 different models, where model 1 and 2 has 2 different layouts.
Model 1 : One page 12 month calendar
This is a calendar with common layout where all dates will be grouped in months from January to December in 12 tables. Dates that have been set as your important dates will have different colors based on their categories.
How to use :
- Select Marking Dates worksheet
- Categorize your events into two big categories, single date category and consecutive dates category.
- Categorize your single date events into 3 subcategories and type their dates as well as their description on column B3-C32 (green table), D3-E32 (red) and F3-G32 (blue). Dates in Calendar worksheet will have the same color with the table. There are maximum 30 events/dates per subcategory.
- Categorize your consecutive dates events into 3 subcategories and type their start and end dates as well as their description on column H4-J11 (yellow table),H14-J21 (brown), H24-J31 (grey). Dates from start until end dates will be marked with the same color with the table. There maximum 8 events per subcategory.
- Select Calendar worksheet and check your dates
- Print the calendar