formula using dates

[bookish]

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?

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?

 

[Sam Wilson]

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

if A1 contains the hire date, this should work.

Sam