Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/EDATE
(view source)
Revision as of 09:53, 4 December 2013
13 bytes added
,
09:53, 4 December 2013
→Description
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>.
−
*
Sd
must be entered in DATE function format or we can enter with in double quotes(" ").
+
*
<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>
M
</math> is not an Integer.
+
#<math>
m
</math> is not an Integer.
==Examples==
==Examples==
Abin
writer
5,435
edits