Excel EDATE

Click Here to download the excel workbook which contains below examples.

EDATE: This Function will help to calculate based upon one particular date the same date in the previous month and the same date for next month.

Note: Result of EDATE function will be in general format we need to convert value to date Format manually.

Quick Snapshot of the Excel EDATE function

Syntax of Excel EDATE

EDATE(serial_number,months)

1st Argument: serial_number this is a compulsory argument

2nd Argument: months this is compulsory argument

Description of Excel EDATE function Arguments

serial_number:- Under this argument we need to
update date in the function or select the cell which has date.

months:- Under this argument, we need to update the number of months for which we want to see the same date.

• To get the dates after the selected date we should give a positive number.
• If we want to get the dates before the selected date then we should give the negative numbers.

Examples of Excel EDATE

Question: Create a table if we enter one date it should give the same date for the next 12 months.

• Cell E22=1/15/2019
• Cell E26=1
• Cell D26=EDATE(D25,E26)
• Result is Cell D26=2/15/2019