| 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== |