The Math column can now do math with date/times. In particular: Subtracting two date/times produces a duration, which is a number and is measured in days, like in Google Sheets. Adding a duration (number) to a date/time, or subtracting it from a date/time will add/subtract that many days to it. Y…

My apologise, I didn’t fully appreciate the logic the first time around, but now I understand what you are doing and it works fine. This is FANTASTIC. Thanks Just one question what the purpose of the “+15”

Essentially what it’s doing taking the entered date, stripping out the DAY number, and subtracting that number from the date, so technically we end up with a date that is the last day of the prior month. Then we add 15 days to get a date that’s in the middle of the entered date’s month and year. So…

Thanks. That was extremely helpful. :exploding_head: :slight_smile:

Hi, I need to do the subtraction like you showed above . But my date column in IF ELSE column. I made If Else Column IF “Start Date” “is Before” “First Jan 2021”. I cannot be subtracted. I try now - start date(Date Type Column) and its works. Please help.

Hmmm, When I try this exactly like you do (I think…) MATH sees it as a date format result… I have to write TRUNC(now - date) to get it to see it as a number… [image]

That behaviour has recently changed. By default subtracting one date from another now gives a number formatted as a duration. As you noted, if you want a number (old behaviour) you need to use trunc or round.

[image] david: Date-time math (e.g. DATEDIFF ) is one of the most common Google Sheets formulas that people still rely on in their Glide apps, but as many of you know, relying on Google Sheets formulas can slow down your app, as Glide must wait for your Google Sheet to update, and then for Googl…

I agree the “MD”, “YM” and “YD” functions are great. You won’t find a way that might be straightforward enough for your liking, but I think it will just take a few more math columns.

It shows “not found”. Could you please repost the link

HI! Could you please share the formula you use to calculate the time between now and a birthday, without requiring a person to enter their last birthday?

🆕 Date-time Math

General

Michael_Weiss June 6, 2022, 9:16am 122

I get an “Invalid operation on date/time” message on the part : year(now) - date

Topic		Replies	Views
Fun with Dates Project Showcase	156	7231	April 19, 2022
New computed column: Math General	95	6513	November 12, 2021
📅 Guide on Dates & Times Community Resources	22	1714	April 2, 2025
🗓 Month, Day, and Year Math Functions Ask for Help	47	3931	July 15, 2023
If then else with DATE Ask for Help	28	3382	May 25, 2022

🆕 Date-time Math

Related topics