formula using dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=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?
 
=date(year(today()),month(A1),day(A1))

if A1 contains the hire date, this should work.

Sam
 
Back
Top