Manuals/calci/EDATE - Revision history

Devika: /* Examples */

2022-02-23T08:57:48Z

Examples

Devika: /* Examples */

2022-02-23T08:57:25Z

Examples

Devika: /* Examples */

2022-02-23T08:55:48Z

Examples

Devika: /* Examples */

2022-02-23T08:54:57Z

Examples

Devika at 19:21, 9 July 2018

2018-07-09T19:21:11Z

Devika at 19:20, 9 July 2018

2018-07-09T19:20:24Z

Devika at 19:19, 9 July 2018

2018-07-09T19:19:26Z

Devika at 19:44, 22 May 2018

2018-05-22T19:44:04Z

Jayaram at 12:19, 13 March 2017

2017-03-13T12:19:32Z

Swapna at 19:18, 7 June 2015

2015-06-07T19:18:58Z

@@ Line 20: / Line 20: @@
 #EDATE("1/1/1910",2) = 03/01/1910
-#=EDATE("5/4/1897",5) = 10/04/1897
+#EDATE("5/4/1897",5) = 10/04/1897
 #EDATE(TODAY()) = 02/23/2022
 #EDATE(TODAY(),2.5) = 05/08/2022

@@ Line 19: / Line 19: @@
 ==Examples==
-#=EDATE("1/1/1910",2) = 03/01/1910
+#EDATE("1/1/1910",2) = 03/01/1910
-#=EDATE("5/4/1897",5) = Mon Tue 04 1897  00:00:00 GMT +0530 (Indian standard time)
+#=EDATE("5/4/1897",5) = 10/04/1897
 #EDATE(TODAY()) = 02/23/2022
 #EDATE(TODAY(),2.5) = 05/08/2022

@@ Line 32: / Line 32: @@
 #EDATE(NOW(),1..5,"quarter")
 {| class="wikitable"|-
-!!start_date !! 	months!!	otherperiodtag!!	EDATE
+!start_date !! 	months!!	otherperiodtag!!	EDATE
 |-
 | Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) ||	1 ||	quarter ||	05/23/2022

@@ Line 19: / Line 19: @@
 ==Examples==
-#=EDATE("1/1/1910",2) = Tue Mar 01 1910  00:00:00 GMT +0530 (Indian standard time)
+#=EDATE("1/1/1910",2) = 03/01/1910
 #=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==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''EDATE (start_date,months)'''</div><br/>
 *<math>start-date</math> is the starting date
 *<math>months</math> is the number of months with <math>+</math> or <math>-</math>
 ==Description==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''EDATE (start_date,months)'''</div><br/>
-*<math>start_date</math> is the starting date
+*<math>start-date</math> is the starting date
 *<math>months</math> is the number of months with <math>+</math> or <math>-</math>
 ==Description==
-*This function gives the date that is mentioned number of months before or after a specified <math>start_date</math>.
+*This function gives the date that is mentioned number of months before or after a specified <math>start-date</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>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>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>start_date</math> or future date
+*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>start_date</math> or past date.
+*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.
 *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
-.The <math>start_date</math> is not a valid date, or if it is not in the DATE function format.
+.The <math>start-date</math> is not a valid date, or if it is not in the DATE function format.
 .<math>months</math> is not an Integer.

@@ Line 10: / Line 10: @@
 *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 issue.
 *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.

← Older revision		Revision as of 12:19, 13 March 2017
Line 34:		Line 34:
	==References==		==References==
	*[https://support.google.com/docs/answer/3092974?hl=en Edate]		*[https://support.google.com/docs/answer/3092974?hl=en Edate]
		+
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]