# 🆕 Date-time Math

**URL:** <https://community.glideapps.com/t/date-time-math/15963>\
**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:** 1\
**Showing post:** 130

<div class="post-metadata">

**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:** [September 27, 2023, 9:49am UTC](https://community.glideapps.com/t/date-time-math/15963/130 "2023-09-27T09:49:50Z")

</div>

See below:

> [@If then else with DATE](https://community.glideapps.com/t/if-then-else-with-date/11328/23):
>
> @Darren_Murphy @Milan_Balogh Geez, I had to put on my thinking cap before my morning coffee. The same place that Darren got that original formula had a second formula. It looks like that old thread is unlisted now, so I won’t link to it, but the second formula dealt with adding years, and also accounted for leap year, so if you added 1 year to Feb 29th, then the next year if would calculated to Feb 28th instead of March 1st. Essentially it would figure out if the month of the future calculate…

---

_[View the full topic](https://community.glideapps.com/t/date-time-math/15963)._