# How to split RSS date entry

**URL:** <https://community.glideapps.com/t/how-to-split-rss-date-entry/796>\
**Category:** Ask for Help\
**Created:** [October 1, 2019, 9:27pm UTC](https://community.glideapps.com/t/how-to-split-rss-date-entry/796 "2019-10-01T21:27:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thomas\_Dahm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_dahm/32/142_2.png) [@Thomas\_Dahm](https://community.glideapps.com/u/Thomas_Dahm)\
**Post date:** [October 1, 2019, 9:27pm UTC](https://community.glideapps.com/t/how-to-split-rss-date-entry/796/1 "2019-10-01T21:27:58Z")

</div>

Hi! I would like to order multiple RSS feeds on date, but can’t figure out how to do it automated.  
The date given by the RSS feed is text, for example, “Fri, 15 Feb 2019 11:00:00 +0100”  
The pattern always repeats itself:  
[day], [date] [month] [YYYY] [HH:mm:ss] [Time Zone offset]

I only need [date] [month] [YYYY] in order [YYYY] [month] [date] (2019/10/02)

made a sample sheet with some not working formulas…

> **[test date](https://docs.google.com/spreadsheets/d/1ku-M_Forb8okrn1PhSdxpU5c3yAGk0kGnQILSIyuzYU/edit?usp=sharing)**
>
> rss
> 
> episode,host,url,date,description
> NM Editor's Picks: October 31th 2022,Thomas Dahm,https://podcasters.spotify.com/pod/show/neonmoireshow/episodes/NM-Editors-Picks-October-31th-...

Thanks in advance

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 2, 2019, 1:57am UTC](https://community.glideapps.com/t/how-to-split-rss-date-entry/796/2 "2019-10-02T01:57:05Z")

</div>

Darn that was a challenging. It has got to be one of the most complex formulas I have ever written in a while.

Plug this into F2 of your rss sheet:

```auto
=ARRAYFORMULA(IF(A2:A<>"";
              DATEVALUE(INDEX(SPLIT(A2:A;" ");0;2) &
              "/" &
              ((FIND(INDEX(SPLIT(A2:A;" ");0;3);"JanFebMarAprMayJunJulAugSepOctNovDec")-1)/3)+1 &
              "/" &
              INDEX(SPLIT(A2:A;" ");0;4));
              "")
             )

```

---

<div class="post-metadata">

**Author:** ![Thomas\_Dahm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_dahm/32/142_2.png) [@Thomas\_Dahm](https://community.glideapps.com/u/Thomas_Dahm)\
**Post date:** [October 2, 2019, 8:21pm UTC](https://community.glideapps.com/t/how-to-split-rss-date-entry/796/3 "2019-10-02T20:21:00Z")

</div>

wow! This works perfectly. Thank you soooo much @George_B! it’s a pretty impressive formula indeed! don’t know if I got it working without your help. Thanks again.

ps. the semicolon is a mystery for me too.

---

<div class="post-metadata">

**Author:** ![Thomas\_Dahm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_dahm/32/142_2.png) [@Thomas\_Dahm](https://community.glideapps.com/u/Thomas_Dahm)\
**Post date:** [October 3, 2019, 9:37am UTC](https://community.glideapps.com/t/how-to-split-rss-date-entry/796/4 "2019-10-03T09:37:23Z")

</div>

@George_B 👋I found a funny thing.  
when in Glide selecting inline list and refer to the column with the formula, Glide shows a number!  
Glide does not recognize in title, description or caption the date format given in the spreadsheet.  
I don’t need it, was just testing. but would be a nice feature… for in the caption though. Thanks again!

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 4, 2019, 2:27am UTC](https://community.glideapps.com/t/how-to-split-rss-date-entry/796/5 "2019-10-04T02:27:41Z")

</div>

I guess you could always format it as text in another column if you did want to display it. something like =TEXT(C6,“mm/dd/yyy”)