You'd have to write some sort of VB.net module to do what you want I think.

As for your actual holiday system ewww. Its a bit complicated isn't it? I get 20 days each year. It gets allocated in January and I've got until December to use it all up. I can take those days whenever I want. Must have 2 weeks off consecutively at some point in the year however.