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 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 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
- The 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.
is not a valid date, or if it is not in the DATE function format.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)