# Help colum math

**URL:** <https://community.glideapps.com/t/help-colum-math/41666>\
**Category:** Ask for Help\
**Created:** [May 5, 2022, 6:04pm UTC](https://community.glideapps.com/t/help-colum-math/41666 "2022-05-05T18:04:39Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**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:** [May 5, 2022, 10:03pm UTC](https://community.glideapps.com/t/help-colum-math/41666/5 "2022-05-05T22:03:09Z")

</div>

This is the latest version of my math formula to add months to a date. It will add the specified number of months, but if the calculated date does not contain the same day number, it will back date to the last day of the goal month. (ex. adding 1 month to Jan 31st will calculate to Feb 28th instead of Mar 3rd). I don’t know if this is exactly what you want. You would have to tell us what should happen if the month you calculate 2 months from now doesn’t contain the same day number as the start date.

> [@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/help-colum-math/41666)._
