Chapter 10. Working with Date and Time Functions


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

Get Business Solutions Formulas and Functions with Microsoft® Office Excel 2007 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.