I have the day of payment (PayDay value).

and that the next payment will be after 1 month.

I need formula which generates date of next payment,

In correlation based with today, I have to pay either this month or next (the formula decides)

there are some peculiarities

If the payment date of the current month has already passed, PayDayToPayDate is before today, then add a period of +1 month to the date. OK

I solved my task with US Date Format and it works well no bugs there.

But EU is bugged - it increases value of month instead of day value.

Am I making a mistake in the formula?

My code here

US_PayDayToPayDate

IF(PayDay,DATETIME_FORMAT(DATETIME_PARSE(MONTH(NOW()) & "/" & PayDay & "/" & YEAR(NOW()), "L"), "L"),"")

US_NextPayment

IF(US_PayDayToPayDate,IF(US_PayDayToPayDate < DATETIME_FORMAT(NOW(), "L"), DATETIME_FORMAT(DATEADD(US_PayDayToPayDate, 1, 'months'), "L"), US_PayDayToPayDate),"")

EU_PayDayToPayDate

IF(PayDay,DATETIME_FORMAT(DATETIME_PARSE(PayDay & "." & MONTH(NOW()) & "." & YEAR(NOW()), "DD.MM.YYYY"), "DD.MM.YYYY"),"")

EU_NextPayment

IF(EU_PayDayToPayDate,IF(EU_PayDayToPayDate < DATETIME_FORMAT(NOW(), "DD.MM.YYYY"), DATETIME_FORMAT(DATEADD(EU_PayDayToPayDate, 1, 'months'), "DD.MM.YYYY"), EU_PayDayToPayDate),"")

JustForTest

DATETIME_FORMAT(DATEADD(EU_PayDayToPayDate, 1, 'months'), "DD.MM.YYYY")