Date-Related Functions
Excel has quite a few functions that work with dates. These functions are accessible by choosing Formulas 
Function Library 
Date & Time.
Table 16-4 summarizes the date-related functions available in Excel.
| Function | Description |
|---|---|
| DATE | Returns the serial number of a particular date |
| DATEVALUE | Converts a date in the form of text to a serial number |
| DAY | Converts a serial number to a day of the month |
| DAYS360 | Calculates the number of days between two dates based on a 360-day year |
| EDATE[*] | Returns the serial number of the date that represents the indicated number of months before or after the start date |
| EOMONTH[*] | Returns the serial number of the last day of the month before or after a specified number of months |
| MONTH | Converts a serial number to a month |
| NETWORKDAYS[*] | Returns the number of whole work days between two dates |
| NOW | Returns the serial number of the current date and time |
| TODAY | Returns the serial number of today’s date |
| WEEKDAY | Converts a serial number to a day of the week |
| WEEKNUM[*] | Returns the week number in the year |
| WORKDAY[*] | Returns the serial number of the date before or after a specified number of workdays |
| YEAR | Converts a serial number to a year |
| YEARFRAC[*] | Returns the year fraction representing the number of whole days between start_date and end_date ... |
Get Office 2007 Bible 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.
