O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required