# Date math - 3 months from a specific date **URL:** \ **Category:** Ask for Help\ **Created:** [July 18, 2022, 4:10pm UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730 "2022-07-18T16:10:54Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [July 18, 2022, 4:10pm UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/1 "2022-07-18T16:10:54Z")
Hi I have been looking around for ages (I’m sure I saw the answer somewhere but I can’t find it!) but I need to calculate 3 months from a date - in a date column. Example : Date Submitted 01/02/2022 - In a date column Result required 01/05/2022 Thanking you already… ---
**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:** [July 18, 2022, 4:25pm UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/2 "2022-07-18T16:25:06Z")
> [@Glide Editor screen goes blank when using Math Column](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646/15): > > Edit: I have some updates to this formula that I’ve explained in the post below. You’re requirement to back Feb 29th by a day if it’s not a leap year does complicate it a bit, but that’s not a problem. It just makes for a formula that’s much larger. Here is the formula if we were to allow Feb 29th to roll over to Mar 1st. ((Now-DAY(Now)+15)+(Years\*365.25)) - DAY((Now-DAY(Now)+15)+(Years\*365.25)) + DAY(Now) ‎ ‎ ‎ ‎ ‎ To get the leap year date of Feb 29th to back date to Feb … ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [July 19, 2022, 7:52pm UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/3 "2022-07-19T19:52:21Z")
@Jeff_Hager our wizard, what about you create a doc (in Notion eg) with all those date/time tricks and all the other spells you’ve created/helped guys here? The most requested and with the most highlights 🔥 I’d love to consult whenever I wanted 😄 ---
**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\ **Post date:** [July 19, 2022, 8:36pm UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/4 "2022-07-19T20:36:02Z")
The easiest that I’ve found is to use Google Sheet’s date math functions. Here’s one that might work best for what you’re doing: [EDATE - Google Docs Editors Help](https://support.google.com/docs/answer/3092974?hl=en) ---
**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:** [July 20, 2022, 12:49am UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/5 "2022-07-20T00:49:57Z")
Do you mean an actual spreadsheet formula in an actual spreadsheet, to do something that can otherwise be done in the Glide Data Editor? 🤔 um, no thanks. ---
**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\ **Post date:** [July 20, 2022, 1:27am UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/6 "2022-07-20T01:27:58Z")
I hear ya @Darren_Murphy! I’m trying to get all of my old apps over to Glide tables whenever I have a free moment. There are some things, in this transition period, and mostly related to date math, that are just easier to do in Google Sheets. Glide now does a great job at handling the addition of days to a date, but if I want to add a year (May 1 to May 1, even in leap years), not so much (yet!). I guess @Rosewebstudio could break apart the date into day, month, and year columns and then add three to the month column and then bring them back together in a Glide table to make the future date. I’ve thought about this when handling leap years. Yes, I can recreate the math in a Glide table, but I’d rather use a function that already exists. Does that make me lazy (he asked himself, on four hours of sleep, wondering if there’s a better way)? No (probably not [maybe a little]). Just taking the path of least resistance. 😉 ---
**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:** [July 20, 2022, 4:08am UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/7 "2022-07-20T04:08:08Z")
@Darren_Murphy @NFNHello Isn’t EDATE possible with the excel formula plugin??? I’ve seen a few posts about it, but I haven’t tried it myself. One thing I like about using the math formula instead, is that I have more control over how leap year dates are handled…especially with Feb 29. Sometimes when adding a year you want Feb 28 and sometimes you want Mar 1 as a result. Plus, dates and plugins don’t seem to work well for you day first people. 😉 ---
**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:** [July 20, 2022, 4:09am UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/8 "2022-07-20T04:09:42Z")
@Lucas_Pires that’s good idea! There’s a lot of formulas floating around the forum that should be better organized. ---
**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:** [July 20, 2022, 4:20am UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/9 "2022-07-20T04:20:30Z")
I’d be willing to collaborate on that one 👍 ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [July 20, 2022, 4:35pm UTC](https://community.glideapps.com/t/date-math-3-months-from-a-specific-date/44730/10 "2022-07-20T16:35:01Z")
> [@Jeff\_Hager](#): > > There’s a lot of formulas floating around the forum that should be better organized. Exactly!