Excel 2000 in a Nutshell

Chapter 13. Date and Time Functions

Virtually every worksheet you create uses at least one value relating to a specific time frame. Typically worksheets are used to display information such as the number of sales for the last year or monthly expenses. The time and date functions covered in this chapter allow you to work with these values more effectively. These functions, for instance, let you perform calculations that determine the number of days between payments, or show how many days are between one payday and the next. Since Excel obtains the date and time information from your system, make sure the date and time on your PC are accurate. The following functions are covered in detail later in this chapter. The “AT” represents those functions that exist only by loading the Analysis Toolpak. See Chapter 11 for details.

DATE	MONTH	WEEKDAY
DATEDIF	NETWORKDAYS AT	WEEKNUM AT
DATEVALUE	NOW	WORKDAY AT
DAY	SECOND	YEAR
DAYS360	TIME	YEARFRAC AT
HOUR	TIMEVALUE
MINUTE	TODAY

Use these functions to do the following:

• Build a date using values from other cells

• Determine the time interval between two different dates

• Determine the numeric value used by Excel to store a specific date or time value

• Manipulate date and time values to return specific portions such as month or hour value

• Determine the number of days between two dates for accounting purposes

• Determine the day of the week on which a specific date falls

• Use the current date and time in your worksheet; the values ...