Manuals/calci/EDATE

EDATE (start_date,months)

$start-date$ is the starting date
is the number of months with or
- EDATE(), returns the serial number of the date that is the indicated number of months before or after the start date.

Description

This function gives the date that is mentioned number of months before or after a specified $start-date$ .
$start-date$ must be entered in DATE function format or we can enter with in double quotes(" ").For e.g EDATE("1/2/1990",2).
$months$ represents the number of months before or after the start date $start-date$ .
If $months$ is positive then the function will display after the $start-date$ or future date
If $months$ is negative then the function will display before the $start-date$ or past date.
It is used to calculate maturity dates or due dates that fall on the same day of the month as the date issue.
We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
This function will show the result as error when

1.The  $start-date$  is not a valid date, or if it is not in the DATE function format.
2. $months$  is not an Integer.

=EDATE("1/1/1910",2) = Tue Mar 01 1910 00:00:00 GMT +0530 (Indian standard time)
=EDATE("5/4/1897",5) = Mon Tue 04 1897 00:00:00 GMT +0530 (Indian standard time)
=EDATE("11/31/1999",3) = Wed Mar 01 2000 00:00:00 GMT +0530 (Indian standard time)
=EDATE("6/6/1979",-2) = Fri Apr 06 1979 00:00:00 GMT +0530 (Indian standard time)
=EDATE("4/15/1950",-6) = Sat Oct 15 1949 00:00:00 GMT +0530 (Indian standard time)