How to do automatic date replacement?

Question

Google Sheets

The task is as follows: It is

necessary to make an automatic date replacement. If the date does not exist, add a month ahead of today's month.
That is, if yesterday was 2021-08-02, then in its place today should be 2021-09-02 The

question may be simple, but I got lost in three pines

Answer 1

If you understand the question correctly, then you can use the formula in Google spreadsheets = DATES ()
as the first parameter, specify the date, the second is the indent in the number of months.