# 🆕 Date-time Math **URL:** \ **Category:** General\ **Tags:** data-editor\ **Created:** [September 17, 2020, 5:47pm UTC](https://community.glideapps.com/t/date-time-math/15963 "2020-09-17T17:47:41Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [September 17, 2020, 5:47pm UTC](https://community.glideapps.com/t/date-time-math/15963/1 "2020-09-17T17:47:41Z")
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. - You can pick “Now” as a substitution for a variable. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b881df2d008dcf1b86391d6efc646811807dbc3f.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6fce87091126f132fef48791839cfe947581faef.png) ---
**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:** [September 17, 2020, 5:50pm UTC](https://community.glideapps.com/t/date-time-math/15963/2 "2020-09-17T17:50:10Z")
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 Google to tell Glide about it. When you do your date calculations in Glide, they update instantly! Here you can see how we use this capability in one of our internal apps to calculate the age (in days) of ideas on our backlog: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/ba5776e8ca28494376a9b3ec95bc5d6f513f4af0.jpeg) ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 17, 2020, 5:52pm UTC](https://community.glideapps.com/t/date-time-math/15963/3 "2020-09-17T17:52:11Z")
Great! ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 17, 2020, 5:54pm UTC](https://community.glideapps.com/t/date-time-math/15963/4 "2020-09-17T17:54:25Z")
This is a big one! Thanks for getting this done! ---
**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:** [September 17, 2020, 5:56pm UTC](https://community.glideapps.com/t/date-time-math/15963/5 "2020-09-17T17:56:57Z")
---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 17, 2020, 5:57pm UTC](https://community.glideapps.com/t/date-time-math/15963/6 "2020-09-17T17:57:00Z")
Let me quickly add a demo of this on my idiots guide 😅 ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [September 17, 2020, 5:59pm UTC](https://community.glideapps.com/t/date-time-math/15963/7 "2020-09-17T17:59:12Z")
Hey @Wiz.Wazeer, do you share that guide of yours? I think it was written for people like me 😂 ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 17, 2020, 6:00pm UTC](https://community.glideapps.com/t/date-time-math/15963/8 "2020-09-17T18:00:05Z")
Anyone can copy it @nathanaelb ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [September 17, 2020, 6:03pm UTC](https://community.glideapps.com/t/date-time-math/15963/9 "2020-09-17T18:03:10Z")
@Mark @david This is really great, thank you. ---
**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:** [September 17, 2020, 6:09pm UTC](https://community.glideapps.com/t/date-time-math/15963/10 "2020-09-17T18:09:08Z")
Marvelous! ---
**Author:** ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)\ **Post date:** [September 17, 2020, 6:11pm UTC](https://community.glideapps.com/t/date-time-math/15963/11 "2020-09-17T18:11:31Z")
@Mark @david This is AMAZING! Thank you!! ---
**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\ **Post date:** [September 17, 2020, 6:12pm UTC](https://community.glideapps.com/t/date-time-math/15963/12 "2020-09-17T18:12:47Z")
If you have a link to the guide, I’d love to see it. ---
**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:** [September 17, 2020, 6:15pm UTC](https://community.glideapps.com/t/date-time-math/15963/13 "2020-09-17T18:15:04Z")
Fantastic!!! 🤩 Once I werent using formula in GS, now I can implement a lot a thing now! Thanks again guys! ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 17, 2020, 6:15pm UTC](https://community.glideapps.com/t/date-time-math/15963/14 "2020-09-17T18:15:22Z")
> **[wiz'z glide sheet](https://glidesheet.glideapp.io/)** > > welcome to wiz'z glide sheet. A complete idiot's guide for dummies ---
**Author:** ![spencerb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencerb/32/4486_2.png) [@spencerb](https://community.glideapps.com/u/spencerb)\ **Post date:** [September 17, 2020, 6:18pm UTC](https://community.glideapps.com/t/date-time-math/15963/15 "2020-09-17T18:18:02Z")
Thanks so much! I need all the help I can get with setting up stuff like this. So cool that this feature is now available in Glide because I had just set up a DATEDIF function to track something. I just need help setting it up because it’s somewhat confusing for me on the Glide end. ---
**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:** [September 17, 2020, 6:18pm UTC](https://community.glideapps.com/t/date-time-math/15963/16 "2020-09-17T18:18:30Z")
# YAAAAAAAAAAAAY!!! ### Thank. You. Glide. Team!!! ---
**Author:** ![Daniel\_Canup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_canup/32/32850_2.png) [@Daniel\_Canup](https://community.glideapps.com/u/Daniel_Canup)\ **Post date:** [September 17, 2020, 6:19pm UTC](https://community.glideapps.com/t/date-time-math/15963/17 "2020-09-17T18:19:20Z")
Sweet!!! I am literarily working on a project now needing this. I was going to just do it in Google Sheets…but now…I won’t have to!!! ---
**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:** [September 17, 2020, 6:20pm UTC](https://community.glideapps.com/t/date-time-math/15963/18 "2020-09-17T18:20:24Z")
Oh my goodness this is the best news of September! # NOW! I’ve been asking for this since September of last year it seems. You guys absolutely rock!!! …now to update, well, ALL my apps 🙂 ---
**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:** [September 17, 2020, 6:22pm UTC](https://community.glideapps.com/t/date-time-math/15963/19 "2020-09-17T18:22:35Z")
Love that you can do Now + 1, etc. I smell increment button combos coming on to cycle through the details screens of daily events 😉 ---
**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:** [September 17, 2020, 6:42pm UTC](https://community.glideapps.com/t/date-time-math/15963/20 "2020-09-17T18:42:45Z")
Great idea!!! 💡 [Next page](https://community.glideapps.com/t/date-time-math/15963.md?page=2)