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")