Changing date information

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top