Manuals/calci/EDATE

From ZCubes Wiki
Jump to navigation Jump to search
EDATE(sd,m)


  • is the starting date
  • is the number of months with or

Description

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

Examples

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

See Also

References