Manuals/calci/EDATE

EDATE (start_date,months)

• $start-date$ is the starting date
• $months$ 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

1. =EDATE("1/1/1910",2) = 03/01/1910
2. =EDATE("5/4/1897",5) = Mon Tue 04 1897 00:00:00 GMT +0530 (Indian standard time)
3. =EDATE("11/31/1999",3) = Wed Mar 01 2000 00:00:00 GMT +0530 (Indian standard time)
4. =EDATE("6/6/1979",-2) = Fri Apr 06 1979 00:00:00 GMT +0530 (Indian standard time)
5. =EDATE("4/15/1950",-6) = Sat Oct 15 1949 00:00:00 GMT +0530 (Indian standard time)
6. EDATE(TODAY()) = 02/23/2022
7. EDATE(TODAY(),2.5) = 05/08/2022
8. EDATE(TODAY(), 2,"week") = 03/09/2022
9. EDATE(TODAY(), 2.5,"week") = 03/12/2022
10. EDATE(TODAY(), -13.5,"week") = 11/20/2021
11. EDATE(NOW(),1,"week") = 03/02/2022
12. 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

Related Videos

EDATE

See Also

• DATE
• DAYS360
• DATEVALUE

References

• Edate

• List of Main Z Functions

• Z3 home