O'Reilly logo

Formulas and Functions with Microsoft® Excel 2003 by Paul McFedries

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

10. Working with Date and Time Functions

IN THIS CHAPTER

How Excel Deals with Dates and Times

Using Excel’s Date Functions

Using Excel’s Time Functions

Case Study

The date and time functions enable you to convert dates and times to serial numbers and perform operations on those numbers. This capability is useful for such things as accounts receivable aging, project scheduling, time-management applications, and much more. This chapter introduces you to Excel’s date and time functions and puts them through their paces with many practical examples.

How Excel Deals with Dates and Times

Excel uses serial numbers to represent specific dates and times. To get a date serial number, Excel uses December 31, 1899, as an arbitrary starting point and then ...

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