Difference between revisions of "Manuals/calci/EDATE"

Revision as of 13:44, 22 May 2018

EDATE(sd,m)

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.
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  $sd$  is not a valid date, or if it is not in the DATE function format.
2. $m$  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)

@@ Line 10: / Line 10: @@
 *If <math>m</math> is negative then the function will display before the <math>sd</math> 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
 .The <math>sd</math> is not a valid date, or if it is not in the DATE function format.