=date(year(today()),month(A1),day(A1))

if A1 contains the hire date, this should work.

Sam

"bookish" wrote:

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?