Manuals/calci/EDATE
Jump to navigation
Jump to search
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)