Holiday Planner vba

Hi all,

I'm working on a holiday Calendar for 2016 (and I want to make it easy to update the years).

See attached an example of what I want to happen.
Attachment 442980
You have 2 Sheets (Vacation) and ( (2016)

I want to be able to update the (2016) sheet as soon as you enter 2 dates in the (vacation sheet). Each employee has a number of days they can take (cells L4-L8)
I want the code to be able to see if there is a weekend in the calendar. and if it is, it doesn't count the days of weekend in that vacation (I now have to enter it manually) It also needs to update the calendar if you take a half day out)

In the file attached, I manually update the calendar so you can see with colors who is taking a vacation. this is with conditional formatting, so it just needs to enter the name of the employee taking the day off.

Can you please help me with completing this, and maybe help me get started with the code?

I know this might not be easy, but I started this project to help me learn VBA more than I do at the moment. so if you help me out, can you please also give some information what the code is doing when?

any help is greatly appreciated, and I will add rep for anyone who is helping me on this..



please find the completed planner here :D