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
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