Difference between revisions of "Manuals/calci/EDATE"
Jump to navigation
Jump to search
Line 29: | Line 29: | ||
==References== | ==References== | ||
− | [http://en.wikipedia.org/wiki/Bessel_function| | + | [http://en.wikipedia.org/wiki/Bessel_function| ] |
Revision as of 22:43, 3 December 2013
EDATE(sd,m)
- is the starting date
- 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 must be entered in DATE function format or we can enter with in double quotes(" ").
- For e.g EDATE("1/2/1990",2). represents the number of months before or after the start date .
- If is positive then the function will display after the or future date
- If is negative then the function will display before the 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
- The is not a valid date, or if it is not in the DATE function format.
- is not an Integer.
Examples
- 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 189700:00:00 GMT +0530 (Indian standard time)
- EDATE("11/31/1999",3) = Wed Mar 01 200000:00:00 GMT +0530 (Indian standard time)
- EDATE("6/6/1979",-2) = Fri Apr 06 197900:00:00 GMT +0530 (Indian standard time)
- EDATE("4/15/1950",-6) = Sat Oct 15 194900:00:00 GMT +0530 (Indian standard time)