MONTH_END

Last date of the month for a date value.

Examples

• MONTH_END(‘4/15/25’) - Returns 04/30/2025.
• MONTH_END(D5) - Returns the last date of the month for the date in cell D5.
• MONTH_END(date{!1}) - Returns the last date of the month for the first date in the date field.