=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