cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SOLVED

converting Text date to a nice date format

surajdevasthali
Occasional Visitor

‎Apr 14 2023 01:58 AM

‎Apr 14 2023 01:58 AM

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. 

 

START DATEEND DATE
MON13MAR23MON13MAR23
TUE14MAR23TUE14MAR23
TUE14MAR23TUE14MAR23
WED15MAR23WED15MAR23
WED15MAR23WED15MAR23
THU16MAR23THU16MAR23
THU16MAR23THU16MAR23
SAT11MAR23SAT11MAR23
WED15MAR23WED15MAR23
WED15MAR23WED15MAR23
WED15MAR23WED15MAR23
TUE14MAR23TUE14MAR23
Labels:
206 Views
0 Likes
1 Reply
Reply
1 Reply
best response confirmed by surajdevasthali (Occasional Visitor)
JosWoolley

‎Apr 14 2023 02:01 AM - edited ‎Apr 14 2023 02:03 AM

‎Apr 14 2023 02:01 AM - edited ‎Apr 14 2023 02:03 AM

Solution

Re: converting Text date to a nice date format

@surajdevasthali 

 

=0+MID(A2,4,25)

 

Format as date.

 

Regards

0 Likes
Reply