Excel Templates | Excel Spreadsheets | 2013/2014 Academic Calendar



2013/2014 Academic Calendar

Posted on July 23, 2013
Filed Under Calendar | 2 Comments


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.

2013 2014 Academic Calendar 88 1024x638 2013/2014 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 :

xlsx 2013/2014 Academic Calendar  2013/2014 Academic Calendar July to July (38.8 KiB, 983 hits)

xlsx 2013/2014 Academic Calendar  2013/2014 Academic Calendar July to June (37.7 KiB, 675 hits)

xlsx 2013/2014 Academic Calendar  2013/2014 Academic Calendar August to August (38.6 KiB, 909 hits)

xlsx 2013/2014 Academic Calendar  2013/2014 Academic Calendar August to July (37.8 KiB, 793 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 icon smile 2013/2014 Academic Calendar , 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

Get Unlocked 2013/2014 Calendars
 2013/2014 Academic Calendar



Comments

2 Responses to “2013/2014 Academic Calendar”

  1. flavio on August 1st, 2013 8:11 pm

    cade a tabela de futebol do campeonato italiano de futebol 2013-
    2014

  2. iTechAsk on September 12th, 2013 5:48 pm

    Great!, All the templates are very necessary for all. Thank You.

Leave a Reply