FUNCTION CATALOGUE / DATE & TIME
EOMONTH Excel function
Returns the end of an offset month.
Correct sentence to use
Find the last day of the month [offset] months from [date].
Modify this query in PlainFormula →Example formula
=EOMONTH(A2,0)
Returns month-end date.
Syntax
EOMONTH(start_date, months)
Argument signature: start_date, months
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.