# Create dynamic date

**URL:** <https://community.glideapps.com/t/create-dynamic-date/62349>\
**Category:** Ask for Help\
**Created:** [June 1, 2023, 8:17am UTC](https://community.glideapps.com/t/create-dynamic-date/62349 "2023-06-01T08:17:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [June 1, 2023, 8:17am UTC](https://community.glideapps.com/t/create-dynamic-date/62349/1 "2023-06-01T08:17:39Z")

</div>

Hi everyone, does anyone know how to make sequential dates by month, in the user table there are dates that must be added to another table, so I made an add row action, the first input is based on a date, for example 1 June 2023, the second input must be 1 August 2023 onward September 1, 2023 onwards.  
how can this be achieved?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e2191e335ffddc5bef8cd102cb3c40818f05715d.png)

---

<div class="post-metadata">

**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 1, 2023, 8:39am UTC](https://community.glideapps.com/t/create-dynamic-date/62349/2 "2023-06-01T08:39:33Z")

</div>

@Jeff_Hager has a good solution for adding any number of months to a date. 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…
