Date Swapping Formula

[jpsimmon]

Hey Guys/Gals,
I have been using a date swap formula to basically swap the month and day between "/" slashes.

=IF(ISTEXT(C7),DATE(RIGHT(C7,4),LEFT(C7,SEARCH("/",C7)-1),MID(C7,SEARCH("/",C7)+1,2)),DATEVALUE(TEXT(C7,"mm/dd/yyyy")))

I originally was working on the formula for sample dates such as: 2/28/2023
But the problem now is; I am running across dates that have the YEAR as just 2-digits, such as: 2/28/23
The result is some of my new dates are coming in as 2/28/23 = Feb 2, 1923. Is there anyway I could make it so it would have this always in the millennium? Such as: 2/28/23 or 2/28/2023 equaling = 28/2/2023.

Can you help? Thanks

 

[JonXL]

Is there a reason you can't just specify the desired formatting in the Formatting dialogue?

DD/MM/YYYY