Use data validation to restrict the entry to dates greater than or equal
to 1/1/2005.

Carlos

"Charlene" wrote in message
...
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