XL: DateValue Function Doesn't Accept Date Literals

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In the versions of Microsoft Excel listed above, the Visual Basic DateValue function does not accept a date literal (for example, #8/12/71#) as an argument.

NOTE: In Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition, the DateValue function DOES accept a date literal.

MORE INFORMATION

In Visual Basic Help, the following information is contained in the entry for the DateValue function:

   The 'date' named argument is normally a string expression
   representing a date from January 1, 100 through December 31, 9999.
   However, 'date' can also be any expression that can represent a
   date, a time, or both a date and time, in that range.

   Type mismatch

The DateValue function accepts only strings that represent dates ("July 4, 1776", "1-Jan-95", "9/1/94", and so on) or other functions that return the same type of information [the DATE() function, the NOW() function, and so on].