ExcelFlux

EDATE function

Calculate the next reporting month boundary.

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

Shift a contract date by whole months. A shorter destination month clips to its final valid day.

A worked example from the workbook

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

Expected result46081

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=EDATE(DATE(2026,11,1),1)
Turkish Excel · tr-TR
=SERİTARİH(TARİH(2026;11;1);1)

Example and expected result

The second argument is a month offset. Starting on the first day gives the next reporting boundary.

Expected result December 1, 2026.

Worked examples

Shift a contract date by whole months. A shorter destination month clips to its final valid day.

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 =EDATE(A7,B7) 46081
Record 2 =EDATE(A8,B8) 45351
Record 3 =EDATE(A9,B9) 46050
Microsoft Excel reference