converting Text date to a nice date format

[surajdevasthali]

Hi All, 

Need help with below text Dateformat extracted from a system. Need your help to convert this text to a nice date format. 

START DATE	END DATE
MON13MAR23	MON13MAR23
TUE14MAR23	TUE14MAR23
TUE14MAR23	TUE14MAR23
WED15MAR23	WED15MAR23
WED15MAR23	WED15MAR23
THU16MAR23	THU16MAR23
THU16MAR23	THU16MAR23
SAT11MAR23	SAT11MAR23
WED15MAR23	WED15MAR23
WED15MAR23	WED15MAR23
WED15MAR23	WED15MAR23
TUE14MAR23	TUE14MAR23

[#2 · Accepted solution]

@surajdevasthali 

=0+MID(A2,4,25)

Format as date.

Regards