Extract date from a string pulled from RSS Feed : Tue, 06 Feb 2018 23:23:40 +0000 to 06/02/2018

[mvrht]

I need to use the date of some fields that are imported from an RSS feed in Google Sheets. The date comes in as
Tue, 06 Feb 2018 23:23:40 +0000






Using
=MID(A1,FIND(",",A1)+2,256)
I get the stuff after the comma, so almost there, but just need to ignore the time section
06 Feb 2018 23:23:40 +0000


I then set the cell to Format-Date to turn it into 06/02/2018
So essentially, I am looking to extract parts 2,3,4 from the string using an Excel/Sheets formula

NOTE: I have also tried DATEVAUE with no success with the supplied RSS format

 

[jmacleary]

If the date format is ALWAYS going to be a 2 digit day followed by a 3 character month and a 4 character year, you could just change your formula to pick up the right number of characters e.g.:

=DATEVALUE(MID(C11,FIND(",",C11)+2,11))

and then format this cell as your desired date format.

 

[mvrht]

If the date format is ALWAYS going to be a 2 digit day followed by a 3 character month and a 4 character year, you could just change your formula to pick up the right number of characters e.g.:

=DATEVALUE(MID(C11,FIND(",",C11)+2,11))

and then format this cell as your desired date format.

Yep, they always come in with that format. This works a treat, many thanks