Changing old Date keeping same Mo. and Day but current Year

[Raven26]

I have a number of hire dates in Column A and would like the excel to show in another column B what their anniversary year is for the current year.

EXAMPLE:

.... ......A....................B..........
1....10/10/55.......10/10/06

2....05/8/88.........05/08/06

 

[Oaktree]

B1 =DATE(2006,MONTH(A1),DAY(A1))

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

 

[Joe4]

As long as the date in A1 is in a date format (and not text):

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

 

[Raven26]

Both these formulas worked great! Thank you very much for your quick reply.