Changes

<div style="font-size:30px">'''EDATE(sd,m)'''</div><br/>

<div style="font-size:30px">'''EDATE(sd,m)'''</div><br/>

*where 's'd ts the starting date and 'm' is the number of months with '+' or '-'   

*<math>sd</math> is the starting date

*<math>m</math> is the number of months with '+' or '-'   

==Description==

==Description==

*This function gives the date that is mentioned number of months before or after a specified sd.

*This function gives the date that is mentioned number of months before or after a specified <math>sd</math>.  

*In EDATE(sd, m) sd indicates the start date .  

*Sd must be entered in DATE function format or we can enter with in double quotes(" ").  

*Sd must be entered in DATE function format or we can entered with in double quotas(" ").  

*For e.g EDATE("1/2/1990",2). <math>m</math> represents the number of months before or after the start date.  

*For e.g EDATE("1/2/1990",2). m is represents the number of months before or after the start date.  

*If <math>m</math> is positive then the function will display after the <math>sd</math> or future 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.  

*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 of issue.  

*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  

*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.

#The <math>sd</math> is not a valid date, or if it is not in the DATE function format.

#'M' is not an Integer.

#<math>M</math> is not an Integer.

==Examples==

==Examples==

#EDATE("1/1/1910",2)=Tue Mar 01 1910 00:00:00 GMT +0530 (Indian standard time)

#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("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("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("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)

#EDATE("4/15/1950",-6) = Sat  Oct  15  194900:00:00 GMT +0530 (Indian standard time)

 

==See Also==

==See Also==

*[[Manuals/calci/DATE  | DATE ]]

*[[Manuals/calci/DATE  | DATE ]]

*[[Manuals/calci/DAYS360  | DAYS360]]

*[[Manuals/calci/DAYS360  | DAYS360]]