Menu
EXCEL EDATE FUNCTION
Excel EDATE Function Introduction
This function returns the same date in future or past months and returns the serial number of the date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
Description of Excel EDATE Function
Syntax:
=EDATE (start_date, months)
Parameter list:
- start_date – a date that represents the start date in a valid Excel serial number format.
- months – the number of months before or after start_date. A positive value to get a future date and negative value for the past date.
Step By Step Guide of EDATE Function
Key Points
If start_date is not a valid date, EDATE returns the #VALUE! error value.
If month entered is not an integer it is truncated.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
