Difference between revisions of "Manuals/calci/EDATE"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''EDATE(sd,m)'''</div><br/> | <div style="font-size:30px">'''EDATE(sd,m)'''</div><br/> | ||
| − | * | + | *<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>. |
| − | + | *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 | + | *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 | + | *If <math>m</math> is positive then the function will display after the <math>sd</math> or future 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 | + | *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. |
| − | # | + | #<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]] | ||
Revision as of 23:18, 3 December 2013
EDATE(sd,m)
- 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 .
- Sd 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.
- This function will show the result as error when
- The is not a valid date, or if it is not in the DATE function format.
- is not an Integer.
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)