|
|
The Excel DATEVALUE Function
Excel Dates & Times
Note that Excel stores dates & times as numerical values. It is purely the formatting of these numbers
that tells Excel to display a date or a time.
For more information on dates & times in Excel, see the Excel Dates & Times page. Basic DescriptionThe Excel Datevalue function converts a text representation of a date, into an Excel date. - ie. the function converts a text string representing a date, into the serial number that represents the date in Excel's date-time code. The syntax of the Datevalue function is :
DATEVALUE( date_text )
where the date_text argument is a text string representing a date. Interpretation of Date Text StringsNote that the Datevalue function follows simple rules that are the same as if you type a date directly into a cell. These are :
These rules are illustrated in the examples below. Datevalue Function ExamplesThe following spreadsheet shows several examples of the Excel Datevalue function. The format of the function is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right.
Note that, in the above example spreadsheet:
For more details on formatting in Excel, go to the Excel Formatting page. Further information and examples of the Excel Datevalue function can be found on the Microsoft Office website. Datevalue Function ErrorIf you get an error from the Excel Datevalue function, this is likely to be the #VALUE! error : Common Error
|
||||||||
|
|
Copyright © 2008-2011 ExcelFunctions.net |