Skip to content

Excel function · Date & time

Excel EOMONTH function

EOMONTH moves forward or back by the number of months you give and returns the last day of that month: the end of the invoice month, the month end two months later. Use it for month-end payment terms and monthly period limits.

In Turkish Excel: SERİAY

What it does

=EOMONTH(A2,0) returns the last day of A2's month, =EOMONTH(A2,1) the last day of the next month and =EOMONTH(A2,-1) the last day of the previous month. Whether the month has 28, 29, 30 or 31 days is handled for you.

Adding 1 to the last day of the previous month gives the first day of this month: =EOMONTH(A2,-1)+1. That way every date can be reduced to the start or end of its month, which makes grouping by month and rules like "month end plus 60 days" easy to build.

To add months while keeping the same day, use EDATE; for the number of days in a month use DAY(EOMONTH(A2,0)) (DAY). For working-day terms, combine the result with WORKDAY.

Syntax

English Excel=EOMONTH(start_date, months)
Turkish Excel=SERİAY(başlangıç_tarihi; ay_sayısı)

Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.

Arguments

ArgumentRequiredDescription
start_dateRequiredThe date, or the cell holding the date, to start from; the day of the month does not matter.
monthsRequiredHow many months to go forward (positive) or back (negative); 0 is the end of the same month.

Examples

1A month-end plus 60 days payment term

Column C finds the last day of the invoice month; column D adds 60 days to it. The day of the month on which the invoice was issued does not change the due date.

C2fx=EOMONTH(B2,0)
A month-end plus 60 days payment term: example table
ABCD
1InvoiceInvoice DateMonth EndDue (Month End + 60)
2F-220112-Jan-202631-Jan-20261-Apr-2026
3F-22023-Feb-202628-Feb-202629-Apr-2026
4F-220330-Oct-202631-Oct-202630-Dec-2026
5F-22045-Nov-202630-Nov-202629-Jan-2027
  • C2 (filled down to C5)=EOMONTH(B2,0)
  • D2 (filled down to D5)=EOMONTH(B2,0)+60

The February invoice's month closes on 28-Feb-2026 and it falls due on 29-Apr-2026. The invoice issued on 5 November falls due in the next year: 29-Jan-2027.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

2Reduce records to the first of the month and total monthly

Column C turns each date into the first day of its month: the previous month's end plus 1. SUMIF in column F adds up by those month starts.

C2fx=EOMONTH(A2,-1)+1
Reduce records to the first of the month and total monthly: example table
ABCDEF
1DateAmountMonth StartMonthTotal
228-Sep-20261,2001-Sep-20261-Sep-20261,200
33-Oct-20268001-Oct-20261-Oct-20263,000
415-Oct-20261,5001-Oct-2026
531-Oct-20267001-Oct-2026
62-Nov-20269501-Nov-2026
  • C2 (filled down to C6)=EOMONTH(A2,-1)+1
  • F2 (filled down to F3)=SUMIF($C$2:$C$6,E2,$B$2:$B$6)

Both 15 October and 31 October become 1-Oct-2026. Adding up by this column gives 1,200 for September and 3,000 for October.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

Common errors and fixes

Shows a number

Cause: The result appears as a number such as 46356 because the cell is not formatted as a date.

Fix: Apply a date format to the cell.

#VALUE!

Cause: The start date is stored as text and cannot be read.

Fix: Convert it to a real date.

Month end left out

Cause: A period condition was written as EOMONTH(A2,0)>B2 instead of B2<=EOMONTH(A2,0), so the last day of the month fell outside the period.

Fix: Write B2<=EOMONTH(A2,0) to include the month end; for dates that carry a time, EOMONTH(A2,0)+1>B2 is safer.

Good to know

  • A term of "60 days from the end of the invoice month": =EOMONTH(A2,0)+60.
  • The first working day after the month end: =WORKDAY(EOMONTH(A2,0),1).

In Nexell

Get Nexell to do it from a sentence

Type this in Nexell

Add a due date column to the invoice list: 60 days from the end of the invoice month

Convert to table

Bring your invoice list into the tool and type this. Nexell adds the due date column with real Excel date formulas and shows it in the preview; in the downloaded file, the due date changes when the invoice date does.

Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.

Free account · no card needed · 30 credits a month

Frequently asked questions

How do I find the first day of the month in Excel?

Add 1 to the last day of the previous month: =EOMONTH(A2,-1)+1. =DATE(YEAR(A2),MONTH(A2),1) gives the same result (DATE).

Related functions

All date & time functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free