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, see the page on Excel Dates & Times Basic DescriptionThe Excel DATEVALUE function converts a text string into an Excel date. - ie. the function converts a string representing a date, into the integer that represents the date in Excel's date-time code. The format of the Datevalue function is : DATEVALUE( date_text )
where the date_text argument is a text string representing a date. Note 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. 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, the text string in cell A5 contains just a day and month. In this case the returned date will use the current year. As these examples were input into Excel in the year 2010, the returned date has the year 2010. FormattingThere is a good chance that your result from the Excel Datevalue function will initially be displayed as a serial number (eg. 39814). This is because the cell containing the formula is not formatted to show dates. To change the formatting to a date format:
For more details, go to the Excel Formatting page. |
|||||
|
|
|||||
Copyright © 2008-2010 ExcelFunctions.net |