Need Calendar Help

School Dist Calendar.zip

I need to input school district calendars in a timeline format in excel by week. We have been manually doing it and I know it can be done with formulas. Please help!

We need to track the days in service and the holidays/breaks, etc., by blacking them out. Is this possible?

I can't get my sample to upload.

We have a calendar from 7/27 labeled Monday, Tuesday, Wednesday, Thursday, Friday and then the next week and so on.

Here are some dates for the first entry:
Start of School End of School Holiday Fall Break Holiday Thanksgiving Break Winter Break Holiday Spring Break Holiday
7/27/2015 6/7/2016 9/7/2015 9/21/2015-10/2/2015 11/11/2015 11/23/2015-11/27/2015 12/21/2015-1/8/2016 1/18/2016 3/21/2016-4/1/2016 5/31/2016
http://i52.photobucket.com/albums/g2...0Calendar2.jpg