Chapter 8

Working with date and time functions

In this chapter, you will:

  • Learn how Excel deals with dates and times

  • Take a tour of Excel’s extensive library of date-related worksheet functions

  • Try out many of Excel’s time-related worksheet functions

Excel’s date and time functions enable you to convert dates and times to serial numbers and perform mathematical 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 ...

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with the O’Reilly learning platform.

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