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.

Table 16-4. Date-Related Functions
FunctionDescription
DATEReturns the serial number of a particular date
DATEVALUEConverts a date in the form of text to a serial number
DAYConverts a serial number to a day of the month
DAYS360Calculates 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
MONTHConverts a serial number to a month
NETWORKDAYS[*]Returns the number of whole work days between two dates
NOWReturns the serial number of the current date and time
TODAYReturns the serial number of today’s date
WEEKDAYConverts 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
YEARConverts 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.