Chapter 16
Working with Dates and Times
IN THIS CHAPTER
Getting an overview of dates and times in Excel
Using Excel date-related functions
Working with Excel time-related functions
Many worksheets contain dates and times in cells. For example, you might track information by date or create a schedule based on time. Beginners often find that working with dates and times in Excel can be frustrating. To work with dates and times, you need a good understanding of how Excel handles time-based information. This chapter provides the information you need to create powerful formulas that manipulate dates and times.
How Excel Handles Dates and Times
This section presents a quick overview of how Excel deals with dates and times. It covers Excel’s date and time serial number system. This section also provides some tips for entering and formatting dates and times.
Understanding date serial numbers
To Excel, a date is simply a number. More precisely, a date is a serial number that represents the number of days since the fictitious date of January 0, 1900. A serial number of 1 corresponds to January 1, 1900; a serial number of 2 corresponds to January 2, 1900; and so ...
Get Office 2013 Bible: The Comprehensive Tutorial Resource 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.