Chapter 7. Date and Time Functions
This chapter describes the Microsoft Excel functions you can use to calculate date and time values. The functions are listed in Table 7-1. These functions also allow you to work with the system time of your computer, so make sure that the system time of your computer is set correctly.
Table 7-1. Overview of the Date and Time Functions
Function | Description |
---|---|
DATE() | Returns the Excel date sequential serial number for a given year, month, and day |
DATEDIF() | Calculates the difference between a start and an end date in years, ... |
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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.