Hello. I need help on an employee absence schedule I'm working on. Any help would be appreciated. I need the calendar to run from April 2015 to March 2016. I'd also like to separate out Sat & Sun with darker bars that move when the year changes. I've added a few formula to the overview that seem to work but I'd appreciate an expert opinion. I'm trying to get it as automated as possible so we can use it year after year.

Again any help would be very much appreciated...

Employee absence schedule-help.xlsx