Microsoft® Excel® 2010 Formulas & Functions Inside Out

Chapter 7. Date and Time Functions

• DATE()

• DATEDIF()

• DATEVALUE()

• DAY()

• DAYS360()

• EDATE()

• EOMONTH()

• HOUR()

• MINUTE()

• MONTH()

• NETWORKDAYS()

• NETWORKDAYS.INTL()

• NOW()

• SECOND()

• TIME()

• TIMEVALUE()

• TODAY()

• WEEKDAY()

• WEEKNUM()

• WORKDAY()

• WORKDAY.INTL()

• YEAR()

• YEARFRAC()

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