Formula for Last Day of Month / End of Month

Hello. If I want to display the last day of the current month in a cell as a date, what is the right formula syntax? In Google Sheets & MS Excel it is EOMONTH (End Of Month). Please help!

Hi John,

It’s a little tricky.

But please try this formula with DATE_ADD () function:

DATE_ADD(DATE_ADD({Date from},1,"month"),-DAY(DATE_ADD({Date from},1,"month")),"days")