Excel Function

EOMONTH

Returns last day of month shifted by months.

EOMONTH(start_date, months)

Arguments

start_date

Required

Enter a date/reference-related value.

months

Required

Enter a numeric value.

Practice Preview

calculate and display date/time values. Use EOMONTH to Returns last day of month shifted by months. use 0 for months. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=EOMONTH(B2, 0)

Practice This Function

Practice in Sequential Mode Back to Function List