# Working Day formula between two date **URL:** \ **Category:** Ask for Help\ **Created:** [December 26, 2022, 10:03pm UTC](https://community.glideapps.com/t/working-day-formula-between-two-date/56065 "2022-12-26T22:03:15Z")\ **Posts on this page:** 1\ **Showing post:** 5
**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:** [December 27, 2022, 7:58am UTC](https://community.glideapps.com/t/working-day-formula-between-two-date/56065/5 "2022-12-27T07:58:59Z")
> [@Sanam\_Shrestha](#): > > Just one more question is there a way to add the date of the next six months automatically in the Glide table? > [@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/working-day-formula-between-two-date/56065)._