Difference between revisions of "Manuals/calci/EDATE"

Latest revision as of 02:57, 23 February 2022

EDATE (start_date,months)

$start-date$ is the starting date
is the number of months with or
- EDATE(), returns the serial number of the date that is the indicated number of months before or after the start date.

Description

This function gives the date that is mentioned number of months before or after a specified $start-date$ .
$start-date$ must be entered in DATE function format or we can enter with in double quotes(" ").For e.g EDATE("1/2/1990",2).
$months$ represents the number of months before or after the start date $start-date$ .
If $months$ is positive then the function will display after the $start-date$ or future date
If $months$ is negative then the function will display before the $start-date$ 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

1.The  $start-date$  is not a valid date, or if it is not in the DATE function format.
2. $months$  is not an Integer.

Examples

EDATE("1/1/1910",2) = 03/01/1910
EDATE("5/4/1897",5) = 10/04/1897
EDATE(TODAY()) = 02/23/2022
EDATE(TODAY(),2.5) = 05/08/2022
EDATE(TODAY(), 2,"week") = 03/09/2022
EDATE(TODAY(), 2.5,"week") = 03/12/2022
EDATE(TODAY(), -13.5,"week") = 11/20/2021
EDATE(NOW(),1,"week") = 03/02/2022
EDATE(NOW(),1..5,"quarter")

start_date	months	otherperiodtag	EDATE
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time)	1	quarter	05/23/2022
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time)	2	quarter	08/23/2022
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time)	3	quarter	11/23/2022
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time)	4	quarter	02/23/2023
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time)	5	quarter	05/23/2023

References

Edate

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''EDATE(sd,m)'''</div><br/>
+<div style="font-size:30px">'''EDATE (start_date,months)'''</div><br/>
-*<math>sd</math> is the starting date
+*<math>start-date</math> is the starting date
-*<math>m</math> is the number of months with <math>+</math> or <math>-</math>
+*<math>months</math> is the number of months with <math>+</math> or <math>-</math>
+**EDATE(), returns the serial number of the date that is the indicated number of months before or after the start date.
 ==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>start-date</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>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>m</math> represents the number of months before or after the start date <math>sd</math>.
+*<math>months</math> represents the number of months before or after the start date <math>start-date</math>.
-*If <math>m</math> is positive then the function will display after the <math>sd</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>m</math> is negative then the function will display before the <math>sd</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>sd</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>m</math> is not an Integer.
+.<math>months</math> is not an Integer.
 ==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("5/4/1897",5) = 10/04/1897
-#EDATE("11/31/1999",3) = Wed Mar 01 2000  00:00:00 GMT +0530 (Indian standard time)
+#EDATE(TODAY()) = 02/23/2022
-#EDATE("6/6/1979",-2) = Fri Apr 06 1979  00:00:00 GMT +0530 (Indian standard time)
+#EDATE(TODAY(),2.5) = 05/08/2022
-#EDATE("4/15/1950",-6) = Sat  Oct 15 1949  00:00:00 GMT +0530 (Indian standard time)
+#EDATE(TODAY(), 2,"week") = 03/09/2022
+#EDATE(TODAY(), 2.5,"week") = 03/12/2022
+#EDATE(TODAY(), -13.5,"week") = 11/20/2021
+#EDATE(NOW(),1,"week")  = 03/02/2022
+#EDATE(NOW(),1..5,"quarter")
+{| class="wikitable"|-
+!start_date !! 	months!!	otherperiodtag!!	EDATE
+|-
+| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) ||	1 ||	quarter ||	05/23/2022
+|-
+| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) ||	2 ||quarter||	08/23/2022
+|-
+| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) ||	3 || quarter ||	11/23/2022
+|-
+| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) ||	4 || quarter ||	02/23/2023
+|-
+| Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) ||	5 || quarter ||	05/23/2023
+|}
+==Related Videos==
+{{#ev:youtube|jKfcBVNSXtA|280|center|EDATE}}
 ==See Also==
@@ Line 29: / Line 53: @@
 ==References==
+*[https://support.google.com/docs/answer/3092974?hl=en Edate]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/EDATE"

Latest revision as of 02:57, 23 February 2022

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search