Hi Bloodywog
While you're pondering the future of this project play with the attached. A new Date Picker is incorporated that does not rely on the presence of the Microsoft Calendar Control. Also notice the Formulas in Roster2012 range A3:A14 which address this issue
modifying Employee names
Your Annual Leave Planner appears to not update properly. I've not worked on this at all so you'll need to look at it.
Let me know how you wish to proceed.