EOMONTH

Try it

When to use it

What does EOMONTH return?

EOMONTH returns the date of the last day of a month, offset by the number of months you specify. A zero offset gives the end of the start date's own month.

How do I get the end of the current month or a future month?

Pass 0 as the second argument for the same month, a positive number for months ahead, or a negative number for months behind the start date.

Use cases

Find a loan's due date three months out

Get the end of the prior month for a closing period

Used in

finance · operations

Syntax

EOMONTH(start,months)

Examples

=EOMONTH(DATE(1969,7,20),1) // => 25446
=EOMONTH(40909,-2) // => 40877
=EOMONTH(DATE(2023,6,15),0) // => 45107