DATEVALUE
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
=DATEVALUE(text)
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.
DAY, MONTH, and YEAR
These functions return the day, month, or year corresponding to a specified date. The date variable can be any ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
