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

#### mvrht

##### New Member
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:

### 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
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
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

Replies
1
Views
290
Replies
11
Views
1K
Replies
6
Views
472
Replies
1
Views
315
Replies
1
Views
39