synchronizing the years for multiple dates

D

Davidjd

I have many dates that I need to sychronize the year on. For example:
1/1/2001, 1/1/2002, 1/1/2005 all need to say 1/1/2005.

It's a long list of different dates all needing the 2005 as their current
year. Retyping isn't an option.
 
D

Dave O

This formula will do it for you:
=DATE(2005,MONTH(A1),DAY(A1))

.... where the 1/1/2001 entry is in cell A1.
 
B

Bob Phillips

In a new column, add

=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

copy down, then copy and pastespecial as values and delete the original
column of dates

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top