# Glide Editor screen goes blank when using Math Column **URL:** https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646 **Category:** Report a Bug **Created:** [December 10, 2020, 5:54am UTC](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646 "2020-12-10T05:54:24Z") **Posts on this page:** 1 **Showing post:** 15
### 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: [January 23, 2021, 12:20am UTC](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646/15 "2021-01-23T00:20:56Z")
**Edit:** I have some updates to this formula that I’ve explained in the post 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… 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. ```auto ((Now-DAY(Now)+15)+(Years*365.25)) - DAY((Now-DAY(Now)+15)+(Years*365.25)) + DAY(Now) ``` ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e0e0f7da5c4028e0f06234e4f8459b6de60d00ae.png) ‎ ‎ ‎ ‎ ‎ To get the leap year date of Feb 29th to back date to Feb 28th instead of Mar 1st, then we need to duplicate a lot of the formula and calculate the month offset to subtract the number of months different as days. So the difference of the current month of February (2), is subtracted from the calculated date of March (3), and the difference (1) is subtracted as a day which rolls March 1st to February 28th. ```auto ((Now-DAY(Now)+15)+(Years*365.25)) - DAY((Now-DAY(Now)+15)+(Years*365.25)) + DAY(Now) - (MONTH(((Now-DAY(Now)+15)+(Years*365.25)) - DAY((Now-DAY(Now)+15)+(Years*365.25)) + DAY(Now))-MONTH(NOW)) ``` ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0f37ac21fd14363d1aebeaf32d3e21050b550c4.png) ‎ ‎ ‎ ‎ ‎ I feel pretty comfortable that this will work with virtually an unlimited number of years since we are still accounting for leap years by multiplying by 365.25 instead of just 365. --- _[View the full topic](https://community.glideapps.com/t/glide-editor-screen-goes-blank-when-using-math-column/19646)._