Create dynamic date

[agung_Taufik]

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?

[Darren_Murphy]

@Jeff_Hager has a good solution for adding any number of months to a date. See below:

If then else with DATE

@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…