thank you for your reply Harald, but I don't think I explained myself very
well.

My employees use Excel to enter timesheet info. If they accidentially enter
the year 2004 instead of 2005, is there a way Excel can automatically change
the year to 2005?

"Harald Staff" wrote:

Hi

With the date of your birth in cell A1, this formula in another cell will
return this year's birthday:
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

HTH. best wishes Harald

"Charlene" skrev i melding
...
How can I make a cell correct the year of a date