# How can I add 6 months to a date in a glide table? **URL:** \ **Category:** Ask for Help\ **Created:** [June 22, 2023, 1:51pm UTC](https://community.glideapps.com/t/how-can-i-add-6-months-to-a-date-in-a-glide-table/63055 "2023-06-22T13:51:40Z")\ **Posts on this page:** 1\ **Showing post:** 2
**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:** [June 22, 2023, 2:10pm UTC](https://community.glideapps.com/t/how-can-i-add-6-months-to-a-date-in-a-glide-table/63055/2 "2023-06-22T14:10:33Z")
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/how-can-i-add-6-months-to-a-date-in-a-glide-table/63055)._