# I need help formatting a date as month

**URL:** <https://community.glideapps.com/t/i-need-help-formatting-a-date-as-month/15178>\
**Category:** Ask for Help\
**Created:** [September 2, 2020, 11:48pm UTC](https://community.glideapps.com/t/i-need-help-formatting-a-date-as-month/15178 "2020-09-02T23:48:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\
**Post date:** [September 2, 2020, 11:48pm UTC](https://community.glideapps.com/t/i-need-help-formatting-a-date-as-month/15178/1 "2020-09-02T23:48:24Z")

</div>

Hi everybody

I need some help about how to format a date MM/DD/YYYY HH:MM in a new calculated (Template??) column which show the MMMM for every single row.

I put an example of what I mean using the google sheet but I need to get this conversion on Glide to obtain the result in new rows.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/87a2825a89089dc7e7aa434f16ed28177835a60c.jpeg)

Thanks

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 3, 2020, 12:06am UTC](https://community.glideapps.com/t/i-need-help-formatting-a-date-as-month/15178/2 "2020-09-03T00:06:32Z")

</div>

You can put this in your F1 cell.

```
={"Month";ARRAYFORMULA(IF(E2:E<>"",TEXT(E2:E,"mmmm"),""))

```

You can see the example here.

> **[ThinhDinh's Glide Lab](https://docs.google.com/spreadsheets/d/1sEQHpSKyHx9w2F_Xx3lm56SU1p-8eI81OYU5TYvQFvw/edit#gid=901882668)**
>
> Robert Test
> 
> Project,Task,Project,Task,Combined
> A,siLxzsQURZK3QGl0Zhqg7w, yLz8ofPiQrC8Y6BYfpm.CQ,A,siLxzsQURZK3QGl0Zhqg7w,A - siLxzsQURZK3QGl0Zhqg7w
> jRzXZcVgQruv37w-gFQ6Kg, zp5bp3uIQoWwJYAH0a-vgQ,yLz8ofPiQrC8Y6BYfpm.CQ,...

---

<div class="post-metadata">

**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\
**Post date:** [September 3, 2020, 12:20am UTC](https://community.glideapps.com/t/i-need-help-formatting-a-date-as-month/15178/3 "2020-09-03T00:20:08Z")

</div>

I appreciate your help.

My first Array formula and it worked properly both in the Google sheet and Glide data.

😊

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 3, 2020, 12:31am UTC](https://community.glideapps.com/t/i-need-help-formatting-a-date-as-month/15178/4 "2020-09-03T00:31:30Z")

</div>

You can check this out 😄

> [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727):
>
> Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 
> 
> > **1/ Definition**
> >
> > Arrayformula is defined as “a range, mathematical expression using one cell range …