ExcelFlux

EOMONTH function

Find the last day of a reporting month.

Date and time

Where can you use it?

Planning and operations teams. Use this group to work with dates and times in calendars, delivery schedules, shifts and period reporting.

Scenario in the workbook

Find month-end reporting cutoffs. A negative offset moves backward.

A worked example from the workbook

RowAB
6Excel date serialMonth offset
7460531
8453221
946081-1
Record 1
=EOMONTH(A7,B7)

Expected result46081

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=EOMONTH(DATE(2026,11,12),0)
Turkish Excel · tr-TR
=SERİAY(TARİH(2026;11;12);0)

Example and expected result

A month offset of 0 returns the end of the starting month.

Expected result November 30, 2026.

Worked examples

Find month-end reporting cutoffs. A negative offset moves backward.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Excel date serial Month offset
7 46053 1
8 45322 1
9 46081 -1
Case Formula Expected result
Record 1 =EOMONTH(A7,B7) 46081
Record 2 =EOMONTH(A8,B8) 45351
Record 3 =EOMONTH(A9,B9) 46053
Microsoft Excel reference