O'Reilly logo

Office 2007 Bible by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh, Cary N. Prague, Faithe Wempen, Herb Tyson, John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required