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, months, or days |
DATEVALUE() | Converts a date as a text value into a date serial number (numeric value) |
DAY() | Extracts the day from a date value |
DAYS360() | Calculates the number of days between two dates based on a year with 360 days (twelve 30-day months) |
EDATE() | Calculates the date a specified number of months before or after the start date |
EOMONTH() | Returns the last date of the month a specified number of months before or after the start date |
Extracts the hour from a time value | |
MINUTE() | Extracts the minute from a time value |
MONTH() | Extracts the month from a date value |
NETWORKDAYS() | Calculates the number of workdays between two dates |
NETWORKDAYS.INTL() | Calculates the number of workdays between two days, allowing the weekend days to be defined (Excel 2010) |
NOW() | Returns the current date and time (the system date and time of the computer) |
SECOND() | Extracts the second from a time value |
TIME() | Calculates a time value based on the indicated hours, minutes, and seconds |
TIMEVALUE() | Converts a time formatted as text into a time value |
TODAY() | Returns the current date (the system date of the computer) |
WEEKDAY() | Converts a date value into a weekday numbered 1 through 7 |
WEEKNUM() | Returns the week number of a date value |
WORKDAY() | Calculates the date before or after a specified number of workdays |
WORKDAY.INTL() | Calculates the date before or after a certain number of workdays, allowing the weekend days to be defined (Excel 2010) |
YEAR() | Extracts the year from a date value |
YEARFRAC() | Calculates the fraction of the year between a start and an end date |