Excel Function

EDATE

Returns date shifted by specified months.

EDATE(start_date, months)

Arguments

start_date

Required

Enter a date/reference-related value.

months

Required

Enter a numeric value.

Practice Preview

Use EDATE to return the result with these settings (Start date: B2 (cell B2 (Start Date in column B)), Months: 1).

Example Table

#
ATask ID
BStart Date
CEnd Date
DNotes
EHoliday
2T0012026/03/012026/03/05Standard task2026/03/03
3T0022026/03/032026/03/10Priority task2026/03/06
4T0032026/03/052026/03/12Standard task2026/03/10
5T0042026/03/082026/03/14Urgent task2026/03/12
6
7
8

How to Use (Formula)

=EDATE(B2, 1)

Result

2026/04/01

Practice This Function

Start Function PracticeBack to Function List

EDATE FAQ

How do I use EDATE in Excel?

Use EDATE when you want to shift a date by a number of months. Enter Start date, Months in that order, then add optional arguments when needed.

Where can I practice EDATE?

Use the "Start Function Practice" button to jump straight into EDATE drills.

What arguments does EDATE use?

The main arguments are Start date, Months. Enter them in order.