# Calculating Future Date **URL:** \ **Category:** Ask for Help\ **Created:** [May 26, 2021, 3:29pm UTC](https://community.glideapps.com/t/calculating-future-date/27260 "2021-05-26T15:29:33Z")\ **Posts on this page:** 1\ **Showing post:** 8
**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 26, 2021, 6:31pm UTC](https://community.glideapps.com/t/calculating-future-date/27260/8 "2021-05-26T18:31:29Z")
Take a look at these posts and see if that works for you. > [@Glide Editor screen goes blank when using Math Column](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646/15): > > 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 problem. It just makes for a formula that’s much larger. Here is the formula if we were to allow Feb 29th to roll over to Mar 1st. ((Now-DAY(Now)+15)+(Years\*365.25)) - DAY((Now-DAY(Now)+15)+(Years\*365.25)) + DAY(Now) ‎ ‎ ‎ ‎ ‎ To get the leap year date of Feb 29th to back date to Feb … Since you are working with months, you may want to replace the Year value with Months, but you will need to add a divide by 12 to convert it to years. > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684/77): > > Here you go. Just use 1.5 years for the number of years, or you can take your number of months and divide by 12. Same thing either way. In the end, you will have a date in the future in that math column and you can then use additional math columns to split out Month(date) and Year(date), then use a template column to put it back together however you want. --- _[View the full topic](https://community.glideapps.com/t/calculating-future-date/27260)._