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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bookish" wrote in message ...
|I have an excel sheet with hire dates in one column and I need a formula that
| will return the same month and day as the hire date but with the current
| year. Any ideas?