Page 255 - Excel Data Analysis

14 537547 AppB.qxd 3/4/03 11:57 AM Page 241

EXCEL FUNCTION QUICK REFERENCE B

DATE AND TIME FUNCTIONS

FUNCTION DESCRIPTION
DATE(year, month, day) Creates a date by combining the specified year, month, and
day values.
DATEVALUE(date_value) Converts a date value into the serial number used by Excel to
store the date.
DAY(serial_number) Returns the day portion of a date.
DAYS360(start_date, end_date[, method]) Calculates the number of days between two dates using
either the U.S. (NASD) or European accounting methods.
EDATE(start_date, months) AT Returns the date that is the specified number of months
before or after a date.
EOMONTH(start_date, months) AT Returns the last day in the month that is the specified
number of months before or after the date.
HOUR(serial_number) Returns the hour portion of a time.
MINUTE(serial_number) Returns the minute portion of a time.
MONTH(serial_number) Returns the month portion of a date.
NETWORKDAYS(start_date, end_date[, holidays]) AT Determines the number of work days between two dates by
excluding any weekend dates and any specified holidays.
NOW() Returns the current date and time.
SECOND(serial_number) Returns the second portion of a time.
TIME(hour, minute, second) Creates a time by combining the specified hour, minute, and
second values.
TIMEVALUE(time_text) Converts a time value into the serial number used by Excel to
store the time.
TODAY() Returns the current date.
WEEKDAY(serial_number[, return_type]) Returns a number from 1 to 7, indicating the day of the week
that a date falls on.
WEEKNUM(serial_number[, return_type]) AT Returns the week number representing the week when the
date occurs in the year.
WORKDAY(start_date, days[, holidays]) AT Finds the date that is the specified number of workdays
before the date.
YEAR(year, month, day) Returns the year portion of a date.
YEARFRAC(start-date, end_date[, basis]) AT Returns a decimal value that represents the fraction of a year
represented by the number of days between two dates.

241