# šŸ—“ Month, Day, and Year Math Functions **URL:** \ **Category:** Ask for Help\ **Created:** [October 9, 2020, 12:12am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937 "2020-10-09T00:12:01Z")\ **Posts on this page:** 20\ **Page:** 2
**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:** [October 9, 2020, 11:00am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/21 "2020-10-09T11:00:28Z")
> [@darder](#): > > Seems that date maths are not working for meā€¦ > Iā€™m using google sheets. > > Missing something? > > ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0ad97b96b8ab594ac261cbf2b1d0c7954ff9be95.jpeg) Hi @Mark Could you please take a look at this? It seems date formulas are not working for meā€¦ I have tried in different sheets with the same resultsā€¦ nothing. A bug or am I missing somethingā€¦? Thanks ---
**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:** [October 9, 2020, 11:50am UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/22 "2020-10-09T11:50:03Z")
Does the capital M at the start make any difference? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 9, 2020, 12:14pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/23 "2020-10-09T12:14:53Z")
What do you have for a value in your Date column? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 9, 2020, 12:20pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/24 "2020-10-09T12:20:22Z")
![Screen Shot 2020-10-09 at 8.18.04 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4804148e8efe3b1b82eb25f6e578e562a65380be.png) It shouldnā€™t matter. I think itā€™s the [math column bug and needs a refresh](https://community.glideapps.com/t/data-disappears/16922/6). Even when I just made this column right now, One of my other columns (a link column even?!) became visibly empty. ---
**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:** [October 9, 2020, 12:21pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/25 "2020-10-09T12:21:52Z")
Same here, I still experienced this today. ---
**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:** [October 9, 2020, 12:27pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/26 "2020-10-09T12:27:01Z")
šŸ˜„ ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [October 9, 2020, 1:03pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/27 "2020-10-09T13:03:38Z")
@darder Could you share your app and tell me where youā€™re adding that column? ---
**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:** [October 9, 2020, 2:06pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/28 "2020-10-09T14:06:20Z")
Thanks @Mark sending you a PMā€¦ ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [October 9, 2020, 7:48pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/29 "2020-10-09T19:48:47Z")
This will be fixed on Thursday. ---
**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\ **Post date:** [February 24, 2021, 3:39pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/30 "2021-02-24T15:39:14Z")
Is there a way to get the number of the day of the year? For instance today would be 31+24=55 the day(d) just returns a 24 for the day of the month. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 24, 2021, 4:11pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/31 "2021-02-24T16:11:02Z")
@spencersRus > [@Find the last day of the following month](https://community.glideapps.com/t/find-the-last-day-of-the-following-month/21557/25): > > Try this: FLOOR(275 \* MONTH(date) / 9) - (FLOOR((MONTH(date) + 9) / 12) \* (1 + FLOOR((YEAR(date) - 4 \* FLOOR(YEAR(date) / 4) + 2) / 3))) + DAY(date) - 30 Donā€™t ask how it works, because I donā€™t know. Found it here. [https://www.epochconverter.com/daynumbers](https://www.epochconverter.com/daynumbers) Also found some other formulas on other sites, but didnā€™t quite understand how to make it work in glide. I thought I would maybe need a seed date column with a Jan 1st to calculate from, but this way works without a seed date. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 24, 2021, 4:16pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/32 "2021-02-24T16:16:05Z")
Itā€™s the gift that just keeps on giving šŸ¤£ šŸ¤£ šŸ¤£ ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 24, 2021, 4:24pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/33 "2021-02-24T16:24:04Z")
I think itā€™s time to start organizing all of these formulas into an app. The list is growing! ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [November 19, 2021, 3:39pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/34 "2021-11-19T15:39:26Z")
Is there a function to get the name of the month from a date? I can do it in google sheets but would be cleaner if I could add a column in glide data. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [November 19, 2021, 3:42pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/35 "2021-11-19T15:42:51Z")
> [@Food2Soil](#): > > Is there a function to get the name of the month from a date? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/96fca82042ad4058ee1c1abeb88a9ccc07979711.png) ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [November 19, 2021, 3:50pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/36 "2021-11-19T15:50:55Z")
cccc gives me weekday. whats the format for month name. is there a list somewhere of all available formats. thanks much! ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [November 19, 2021, 3:53pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/37 "2021-11-19T15:53:27Z")
Oh oops! [luxon - Immutable date wrapper](https://moment.github.io/luxon/#/formatting?id=table-of-tokens) ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [November 19, 2021, 3:54pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/38 "2021-11-19T15:54:59Z")
yay! thankyou! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [November 19, 2021, 4:06pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/39 "2021-11-19T16:06:19Z")
Slightly more verbose, but here is how I do it: - I have a table that lists the month names in a single column - I use a math column to determine the month number from the date `Month(date)-1` - I then use a single value column to ā€œfetchā€ the correct month name, using the ā€œfrom startā€ option, and feeding that the output of the math column ![Screen Shot 2021-11-20 at 12.03.30 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c6d9c00ddffc0b73bc48987da9b5c027eb41eb0.png) The only reason I offer this option is because Iā€™m aware that the Date Format plugin has been known to fail with some combinations of user locale and/or date format. ---
**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\ **Post date:** [November 30, 2021, 10:04pm UTC](https://community.glideapps.com/t/month-day-and-year-math-functions/16937/40 "2021-11-30T22:04:53Z")
thankyou! [Previous page](https://community.glideapps.com/t/month-day-and-year-math-functions/16937.md?page=1) [Next page](https://community.glideapps.com/t/month-day-and-year-math-functions/16937.md?page=3)