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…

[image] Glide Editor screen goes blank when using Math Column Report a Bug 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 pr…

@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 :fire: I’d love to consult whenever I wanted :smile:

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

Do you mean an actual spreadsheet formula in an actual spreadsheet, to do something that can otherwise be done in the Glide Data Editor? :thinking: um, no thanks.

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…

@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 w…

@Lucas_Pires that’s good idea! There’s a lot of formulas floating around the forum that should be better organized.

I’d be willing to collaborate on that one :+1:

[image] Jeff_Hager: There’s a lot of formulas floating around the forum that should be better organized. Exactly!

Date math - 3 months from a specific date

Ask for Help

Jeff_Hager July 18, 2022, 4:25pm 2

2 Likes

Topic		Replies	Views
Calculating next anniversary in Glide Ask for Help	2	656	August 25, 2021
How to calculate next month/year from a specified date Ask for Help	1	891	September 5, 2021
Help colum math Ask for Help	10	519	May 7, 2022
Is rolling up summary values based on dates - is there an easier way to do this? Ask for Help	8	756	October 28, 2022
Calculating Future Date Ask for Help	8	1251	January 17, 2024

Date math - 3 months from a specific date

Related topics