Manuals/calci/EDATE

EDATE(sd,m)

• $sd$ is the starting date
• $m$ is the number of months with $+$ or $-$

Description

• This function gives the date that is mentioned number of months before or after a specified $sd$.
• $sd$ must be entered in DATE function format or we can enter with in double quotes(" ").
• For e.g EDATE("1/2/1990",2). $m$ represents the number of months before or after the start date $sd$.
• If $m$ is positive then the function will display after the $sd$ or future date
• If $m$ is negative then the function will display before the $sd$ 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.
• This function will show the result as error when

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

Examples

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

See Also

• DATE
• DAYS360
• DATEVALUE