Correct.

Excel is not able to work with dates before 1-1-1900. So 4/25/200 is not an
Excel date, 4/25/20 is, because Excel assumes 2020 then.
If you need this, you'll have to manipulate the "date" as a string (TEXT) to
extract month and day.

--
Kind regards,

Niek Otten

"kevin" wrote in message
...
I apologize for multi-posting.

As for your formula it does not work
if you type 4/25/200 in one field and use your formula you get a #value!
error

"Niek Otten" wrote:

=DATE(2006,MONTH(A1),DAY(A1))

--
Kind regards,

Niek Otten

"kevin" wrote in message
...
I have data that has dates of 4/25/200, 4/25/20,4/25/2020

How do I change the year to show 2006 without changing the month or day