Difference between revisions of "Manuals/calci/EDATE"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
==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>sd</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>m</math> represents the number of months before or after the start date <math>sd</math>. | *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>. | ||
*If <math>m</math> is positive then the function will display after the <math>sd</math> or future date | *If <math>m</math> is positive then the function will display after the <math>sd</math> or future date | ||
| Line 12: | Line 12: | ||
*This function will show the result as error when | *This function will show the result as error when | ||
#The <math>sd</math> is not a valid date, or if 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> | + | #<math>m</math> is not an Integer. |
==Examples== | ==Examples== | ||
Revision as of 03:53, 4 December 2013
EDATE(sd,m)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd} is the starting date
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m} is the number of months with Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle +} or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle -}
Description
- This function gives the date that is mentioned number of months before or after a specified Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd} .
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd} must be entered in DATE function format or we can enter with in double quotes(" ").
- For e.g EDATE("1/2/1990",2). Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m} represents the number of months before or after the start date Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd} .
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m} is positive then the function will display after the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd} or future date
- If is negative then the function will display before the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd} 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
is negative then the function will display before the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd}
or past date.- The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd} is not a valid date, or if it is not in the DATE function format.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m} 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)