Changes

Jump to navigation Jump to search
no edit summary
Line 1: Line 1: −
<div style="font-size:30px">'''EDATE(sd,m)'''</div><br/>
+
<div style="font-size:30px">'''EDATE (start_date,months)'''</div><br/>
*<math>sd</math> is the starting date
+
*<math>start_date</math> is the starting date
*<math>m</math> is the number of months with <math>+</math> or <math>-</math>   
+
*<math>months</math> is the number of months with <math>+</math> or <math>-</math>   
    
==Description==
 
==Description==
*This function gives the date that is mentioned number of months before or after a specified <math>sd</math>.  
+
*This function gives the date that is mentioned number of months before or after a specified <math>start_date</math>.  
*<math>sd</math> must be entered in DATE function format or we can enter with in double quotes(" ").For e.g EDATE("1/2/1990",2).   
+
*<math>start_date</math> must be entered in DATE function format or we can enter with in double quotes(" ").For e.g EDATE("1/2/1990",2).   
*<math>m</math> represents the number of months before or after the start date <math>sd</math>.  
+
*<math>months</math> represents the number of months before or after the start date <math>start_date</math>.  
*If <math>m</math> is positive then the function will display after the <math>sd</math> or future date
+
*If <math>months</math> is positive then the function will display after the <math>start_date</math> or future date
*If <math>m</math> is negative then the function will display before the <math>sd</math> or past date.  
+
*If <math>months</math> is negative then the function will display before the <math>start_date</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.  
 
*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]".
 
*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  
 
*This function will show the result as error when  
  1.The <math>sd</math> is not a valid date, or if it is not in the DATE function format.
+
  1.The <math>start_date</math> is not a valid date, or if it is not in the DATE function format.
  2.<math>m</math> is not an Integer.
+
  2.<math>months</math> is not an Integer.
    
==Examples==
 
==Examples==
writer
6,694

edits

Navigation menu