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 DATEEND DATEMON13MAR23MON13MAR23TUE14MAR23TUE14MAR23TUE14MAR23TUE14MAR23WED15MAR23WED15MAR23WED15MAR23WED15MAR23THU16MAR23THU16MAR23THU16MAR23THU16MAR23SAT11MAR23SAT11MAR23WED15MAR23WED15MAR23WED15MAR23WED15MAR23WED15MAR23WED15MAR23TUE14MAR23TUE14MAR23

surajdevasthali =0+MID(A2,4,25) Format as date. Regards

Copper Contributor

Apr 14, 2023

Solved

converting Text date to a nice date format

Hi All,

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