Microsoft Office Tutorials and References
In Depth Information
Using DATEVALUE to Convert Text Dates to Real Dates
Caution
The DATEVALUE function must be used with text dates. If you have a
column of values in which some values are text and some are actual
dates, using DATEVALUE on the actual dates causes a #VALUE error.
You could use =IF(ISNUMBER(A1),A1,DATEVALUE(A1)). Also consider
the new =DAYS(End,Start) function, which deals with either text dates
or real dates.
Any of the text values in column A of Figure 11.40 are successfully trans-
lated to a date serial number. In this instance, Excel should have been smart
enough to automatically format the resulting cells as dates. By default,
the cells are formatted as numeric. This leads many people to believe that
DATEVALUE doesn t work. You have to apply a date format to achieve the
desired result.
Figure 11.40.
Figure 11.40. The formulas in column B use
The formulas in column B use DATEVALUE
to convert the text
entries in column A to date serial numbers.
DATEVALUE to convert the text
entries in column A to date serial numbers.
Search JabSto ::




Custom Search