Chapter 3
Date and Time Formulas
IN THIS CHAPTER
Understanding dates and times in Excel
Creating formulas that calculate elapsed dates and times
Using the Date functions
Using the Time functions
Creating formulas that use dates and times can be a little confusing if you don’t have a good understanding of how Excel treats these types of values. After you’re equipped with this understanding, you can begin to make good use of the many Date and Time functions that the program offers.
This chapter begins with a quick overview of date and time numbers in Excel and how you can use them to build simple formulas that calculate differences between elapsed dates and times. The chapter goes on to survey Excel's built-in Date and Time functions, which enable you to return and calculate with dates and times.
Understanding Dates and Times
Excel doesn’t treat the dates and times that you enter in the cells of your worksheet as simple text entries. (For more information on inputting numbers in a worksheet, see Book 2, Chapter 1.) Any entry with a format that resembles one of the date and time ...
Get Excel All-in-One For Dummies 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.
