Hi All;

I'm tryingto create a spreadsheet to track all employees holiday time
off and have a worksheet for each month and a summary sheet.

What i want to do is have a new sheet with the year on it so that each
month would change according to what year was put in. I've looked at all
the formulas for Date and Year and am about to go mad.

Any help would be appreciated.


Tik