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

DATEVALUE(date_text)

 
 Returns the serial number that represents a given date in text format.

 date_valueThe text string that represents the date.

 REMARKS
 
  		• If "date_value" contains any time information, it is ignored.
     
  		• If "date_value" is not a valid date, then #VALUE! is returned.
     
  		• If the year portion of "date_text" is left blank, the current year is used.
     
  		• Acceptable date forms will vary from system to system and will also depend on the users settings.
     
  		• Most functions will automatically convert date strings to serial numbers.
     
  		• The date format can be any of those on the (Format > Cells)("Number" tab).

     EXAMPLES
     
     A
    1=DATEVALUE("22-AUG-1998") = 36029
    2=DATEVALUE("22 August 98") = 36029
    3=DATEVALUE("2002/02/23") = 37310
    4=DATEVALUE("1-JUL") = 39264
    5=DATEVALUE("1 Jul 2003") = 37803
    6=DATEVALUE("8/22/1998") = #VALUE!
    		 
     Functions - D | Index - D | Dates & Times | Office Online 

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