1. M

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

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

Some videos you may like

This Week's Hot Topics