Difference between revisions of "Manuals/calci/EDATE"
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
==See Also== | ==See Also== | ||
*[[Manuals/calci/DATE | DATE ]] | *[[Manuals/calci/DATE | DATE ]] | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/DAYS360 | DAYS360]] |
*[[Manuals/calci/DATEVALUE | DATEVALUE]] | *[[Manuals/calci/DATEVALUE | DATEVALUE]] | ||
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Bessel_function| Bessel Function] | [http://en.wikipedia.org/wiki/Bessel_function| Bessel Function] | ||
Revision as of 04:55, 3 December 2013
EDATE(sd,m)
- where 's'd ts the starting date and '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.
- In EDATE(sd, m) sd indicates the start date .
- Sd must be entered in DATE function format or we can entered with in double quotas(" ").
- For e.g EDATE("1/2/1990",2). m is represents the number of months before or after the start date.
- Suppose m is positive value then the function will display the after the sd or future date or m is negative value then the function will display the 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 of issue.
- This function will show the result as error when
- The sd is not a valid date,or it is not in the DATE function format.
- 'M' 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)