This function converts a text string into a valid date (in other words, a date serial number). The text string must contain data that is recognizable as a date. The function recognizes text entered in any of the date formats shown in the Number tab in the Format Cells dialog box, when you choose the Date category. You can specify any date from January 1, 1900 to February 6, 2040. The format of a DATEVALUE function is
An example of the DATEVALUE function and its result is
= DATEVALUE (B5), where B5 contains 1/25/91
The result, 31801, is the number of days between 1/1/00 and 1/25/91.
These functions return the day, month, or year corresponding to a specified date. The date variable can be any ...