Formula to return the same day of next month (handling month-end and year change)

[Boray]

Hi AppSheet community,
I’m trying to create a formula that, given a date, returns the same day in the next month with the following considerations:
• For example, if today is July 15, it should return August 15.
• If the same day does not exist in the next month (like January 31 → February 28 or 29), it should return the last day of that next month.
• If the date is in December, it should return the same day but in the next year (e.g., December 31 → January 31 next year).

I spent huge time but I couldn't figure it out. could someone help mo te create this function correctly

Thanks in advance!

[Suvrutt_Gurjar · Accepted solution]

Please try 

IF(DAY(TODAY())=31, EOMONTH(TODAY(),1),

EOMONTH(TODAY(), 0) +DAY(TODAY())

)

Please test well.