Increase dates

[koviac]

I have a robot that increments dates, I have an initial date and a column with the number of times I need the months to increment, for example 1:
Initial date = 02/15/2024
Increment months: 2
New date: 04/15/2024
Example 2
Initial date = 05/31/2024
Increment months = 4
New date = 10/01/2024 (because September only has 30 days.)
Example 3
Initial date: 10/02/2024
Increment months: 2
New date: 12/02/2024
What I need is for the day to be constant, not to change, but if the initial date is 31 but the next month only has 30 days, go to the next day.

Which formula can I use?

[Aurelien · Accepted solution]

Hi @koviac 

You may want to have a look there:

EOMONTH() - AppSheet Help

[AleksiAlkio]

For visibility.. the formula should be something like
EOMONTH([InitialDate],-1+[Months])+DAY([NewDate])