EOMONTH Function Generator
EOMONTH returns the last day of the month that is a specified number of months before or after a start date. Core function for financial close calendars, invoice due dates, and period buckets.
Syntax
=EOMONTH(start_date, months)Try it — generate a EOMONTH formula
Examples
Last day of current month
=EOMONTH(TODAY(), 0)Today + 0 months, returns end of this month.
Net-30 due date (end of month)
=EOMONTH(A2, 1)Last day of the month after invoice date A2.
Start of next month
=EOMONTH(A2, 0)+1End of this month plus 1 day = first of next.
Tips
- ✓Positive months = future, negative = past.
- ✓Format the result as a date — EOMONTH returns a serial number.
- ✓Pair with DATE and DAY to build period headers.
Related Formulas
WORKDAY
WORKDAY returns a date that is a given number of business days before or after a...
NETWORKDAYS
NETWORKDAYS calculates the number of working days between two dates, automatical...
DATEDIF
DATEDIF calculates the difference between two dates in days, months, or years. P...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free