This is a new academic calendar template for year 2013/2014. There is no change in the layout of the calendar at all. The difference only on the dates. I haven’t had enough time to add more features on this calendar due to other projects, eventhough I have some ideas which should be nice if being implemented in the calendar. I hope I can implement it on the next academic calendar.
How to use:
There are two working worksheets in each templates. The first one is the worksheet where you can type the date, either fixed or range date, of all your school activities. The second one is the calendar worksheet which has the formula to map the activities that you have typed in the first worksheet in related dates marked by 6 different colors.
Marking single dates:
> Type exams date in column B as well as its description in column C (green markers).
> Type holiday date in column D as well as its description in column E (red markers). Replace default US holidays with your own holidays.
> Type event date on column F as well as its description on column G (blue markers).
Marking consecutive dates:
> Type start date in column H, end date in column I, as well as its description in column J.
–Start and end dates in row 2-9 (H4-I11) will have brown markers
–Start and end dates in row 12-19 (H14-I21) will have yellow markers
–Start and end dates in row 22-29 (H24-I31) will have grey markers
You can download those four academic calendar templates below. They need at least Microsoft Excel version 2007 to make all conditional formatting work well :
2013/2014 Academic Calendar July to July (38.8 KiB, 1,133 hits)
2013/2014 Academic Calendar July to June (37.7 KiB, 799 hits)
2013/2014 Academic Calendar August to August (38.6 KiB, 1,052 hits)
2013/2014 Academic Calendar August to July (37.8 KiB, 922 hits)
If you are interested to see how the consecutive date marker formula works or you want to customize them and make them as your official school academic calendar or just want to thank me :), you can have the unlocked version by sending me $4.99 through paypal by clicking the button below.
You will also will get unlocked version of 2013 and 2014 calendars. These are list of calendars that you will get.
– Unlocked 2013 and 2014 Calendar – Portrait
– Unlocked 2013 and 2014 Calendar – Landscape
– Unlocked 2013 and 2014 Linear Calendar
– Unlocked 2013 and 2014 Calendar with Notes – Vertical Month Arrangement with 7 Different Marking Color
– Unlocked 2013 and 2014 Calendar with Notes – Horizontal Month Arrangement with 7 Different Marking Color
– Unlocked July 2013/June 2014 Academic Calendar
– Unlocked July 2013/July 2014 Academic Calendar
– Unlocked August 2013/July 2014 Academic Calendar
– Unlocked August 2013/August 2014 Academic Calendar