Hi,

I have a list of dates as below:
01/01/07
01/02/07
01/03/07
01/04/07 etc for a whole year

However, I'd like the list to change to 08, 09, 10 etc. when the year
changes. I tried doing this by entering the TODAY formula into a cell and
then using the YEAR formula to extract the correct year. I then entered the
formula =01/01/'cell with year formula in' into the first cell of my dates
range but this did not work.

I'm sure there's a simple way around this. I'd be greatful if anyone could
point me in the right direction.

Thanx