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

mvrht

New Member
Joined
Dec 9, 2017
Messages
18
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
 
Last edited:

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

jmacleary

Well-known Member
Joined
Oct 5, 2015
Messages
1,026
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
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

New Member
Joined
Dec 9, 2017
Messages
18
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,019
Messages
5,526,290
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top