Difference between revisions of "Manuals/calci/EDATE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''EDATE (start_date,months)'''</div><br/> | <div style="font-size:30px">'''EDATE (start_date,months)'''</div><br/> | ||
| − | *<math> | + | *<math>start-date</math> is the starting date |
*<math>months</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> | + | *This function gives the date that is mentioned number of months before or after a specified <math>start-date</math>. |
| − | *<math> | + | *<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>months</math> represents the number of months before or after the start date <math> | + | *<math>months</math> represents the number of months before or after the start date <math>start-date</math>. |
| − | *If <math>months</math> is positive then the function will display after the <math> | + | *If <math>months</math> is positive then the function will display after the <math>start-date</math> or future date |
| − | *If <math>months</math> is negative then the function will display before the <math> | + | *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> | + | 1.The <math>start-date</math> is not a valid date, or if it is not in the DATE function format. |
2.<math>months</math> is not an Integer. | 2.<math>months</math> is not an Integer. | ||
Revision as of 13:20, 9 July 2018
EDATE (start_date,months)
- is the starting date
- is the number of months with or
is the starting date
is the number of months with 
or 
Description
- This function gives the date that is mentioned number of months before or after a specified .
- must be entered in DATE function format or we can enter with in double quotes(" ").For e.g EDATE("1/2/1990",2).
- represents the number of months before or after the start date .
- If is positive then the function will display after the or future date
- If is negative then the function will display before the 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.
- 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
1.The is not a valid date, or if it is not in the DATE function format. 2. 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 1897 00:00:00 GMT +0530 (Indian standard time)
- =EDATE("11/31/1999",3) = Wed Mar 01 2000 00:00:00 GMT +0530 (Indian standard time)
- =EDATE("6/6/1979",-2) = Fri Apr 06 1979 00:00:00 GMT +0530 (Indian standard time)
- =EDATE("4/15/1950",-6) = Sat Oct 15 1949 00:00:00 GMT +0530 (Indian standard time)
Related Videos
See Also
References