# Google sheets date functions in Glide

**URL:** <https://community.glideapps.com/t/google-sheets-date-functions-in-glide/19387>\
**Category:** Ask for Help\
**Created:** [December 4, 2020, 4:06pm UTC](https://community.glideapps.com/t/google-sheets-date-functions-in-glide/19387 "2020-12-04T16:06:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\
**Post date:** [December 4, 2020, 4:06pm UTC](https://community.glideapps.com/t/google-sheets-date-functions-in-glide/19387/1 "2020-12-04T16:06:45Z")

</div>

Hi Guys,  
I would like to build a statistic chart in one of my (numerous) apps.  
I Would like to know if it is possible in Glide to extract a month out of a date (i.e 12/4/2020 into “December”)  
In Google sheet I used =UPPER(TEXT(cell,“MMMM”). however it requires for me to log into the source sheet and update the formula manually.  
Is there another way to make my life easier?  
Merci beaucoup mes chéris

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [December 4, 2020, 4:13pm UTC](https://community.glideapps.com/t/google-sheets-date-functions-in-glide/19387/2 "2020-12-04T16:13:21Z")

</div>

Hi @Fanny_Ditomene_Sekwe,

Yes this is possible. Add a new math column.

In the configuration, have something like. Month(m)

Then in replacement, have “m” replace by the date.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a027e6b2d6bb07ccd5dc77366aa8ab545b5aa52.jpeg)

I hope this works for you.

---

<div class="post-metadata">

**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\
**Post date:** [December 4, 2020, 5:40pm UTC](https://community.glideapps.com/t/google-sheets-date-functions-in-glide/19387/3 "2020-12-04T17:40:31Z")

</div>

Hi @SantiagoPerez,

Many thanks the trick. I need one extra step. I applied an IF\>THAN\>ELSE Column to convert the number into Actual Month.

God bless you

---

<div class="post-metadata">

**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\
**Post date:** [December 4, 2020, 5:55pm UTC](https://community.glideapps.com/t/google-sheets-date-functions-in-glide/19387/4 "2020-12-04T17:55:38Z")

</div>

Heads up, It also works with years Years(y) !!!whoop whoop 😍