Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Date and Time > EDATE
 

EDATE(start_date, months)

 
 Returns the serial number that is a given number of months before or after a date.

 start_dateThe start date.
 monthsThe number of months before or after the "start date".

 REMARKS
 
  		• This function is only available if you have the Analysis ToolPak add-in installed.
     
  		• This function can be used to calculate maturity dates or due dates that fall on the same day on the month as the date of issue.
     
  		• If "start_date" is not a valid date, then #VALUE! is returned.
     
  		• If "months" is not an integer, it is truncated.
     
  		• If "months" > 0, then a date in the future is returned.
     
  		• If "months" < 0, then a date in the past is returned.
     
  		• If "months" = 0, then "start_date" is returned.
     
  		• You should try and enter your dates using the DATE() function.
     
  		• You can use the TEXT() function to convert a date serial number into a particular date format.
     
  		• You can use the DATEVALUE() function to return the serial number representing a date in a text format.

     EXAMPLES
     
     A
    1=EDATE("01/07/1977",2) = 28369
    2=EDATE("01/07/1977",2) = 01/09/1977
    3=EDATE("01/07/1977",4) = 01/11/1977
    4=EDATE("01/07/1977",-2) = 01/05/1977
    5=EDATE("2002/01/09",0) = 09/01/2002
    6=TEXT(EDATE("13 Jun 2003",3),"dd mmmm yyyy") = 13 September 2003
    7=TEXT(EDATE("01/07/1977",0),"dd/mm/yy") = 01/07/77
    8=EDATE(DATEVALUE("01/12/1998"),1) = 01/01/1999
    9=EDATE(DATEVALUE("03/31/1998"),-1) = #VALUE!
    		 
     Functions - E | Index - E | Dates & Times | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top