Find the last day of the following month

[Darren_Murphy]

@Milan_Balogh

Is there an easy way to simply get +1 month? Next week is super simple, but I couldn’t figure this out.

heh… I posted a video about 10 minutes ago that shows how to do this

If then else with DATE

@Food2Soil - here, I think this is a better approach… The math formulas used: To add an arbitrary number of months to a date: ((Now-DAY(Now)+15)+(Years/12*365.25)) - DAY((Now-DAY(Now)+15)+(Years/12*365.25)) + DAY(Now) To get midnight on the first day of the month from a given date: Date+1-Day(Date)-Hour(Date)/24-Minute(Date)/1440-Second(Date)/86400