Changing date information

[Guest]

I have a sequence of dates in a previous worksheet and I would like to update the date (year value) to this years value. Could someone please give me an idea of how to do this.

Thanks in advance.

 

[RagDyeR]

If all the dates are different years, you could try this:

=DATE(2004,MONTH(A1),DAY(A1))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I have a sequence of dates in a previous worksheet and I would like to
update the date (year value) to this years value. Could someone please give
me an idea of how to do this.

Thanks in advance.