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

It is not clear what you want to do with these formula.

Be clearer on what sheets the workbook will hold, and what data each sheet
will need.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Corey na" wrote in message
news:2xEKf.54071$B94.28934@pd7tw3no...
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