Microsoft Office Tutorials and References
In Depth Information
CHAPTER 4 Date and Time Functions
4
CHAPTER
Date and Time Functions
Date and Time Functions Overview
Date and time functions are powerful functions that allow you to automate and
manage information dealing with time elements. For example, if you have a daily
report that goes out and you always want the report to include the day it was printed,
you could manually enter the date into a cell or let Excel’s date formula of TODAY() do
it for you. The value of date and time formulas reaches much further than a simple
date in a cell. It can also help you manage time by calling out due dates, weekends,
holidays, or dates that are past due. You can find maturity dates, and create
calculators that manage your bills and combine formulas to see workdays in the future.
Unlike most other numeric data, when you enter a date or a formula that
calculates a date, in most cases, Excel will automatically display the result in an easily
readable date format. The date is really a serial number representing the time
elapsed since 12:00 AM, Januar y 1, 1900. When you are comparing two dates,
Excel is really looking at the serial numbers. Therefore, one date minus another
date is really one serial number subtracted from another serial number, with the
result converted back into a date format.
This chapter covers the following functions.
DATE
NOW
DATEVALUE
SECOND
DAY
TIME
DAYS360
TIMEVALUE
EDATE
TODAY
EOMONTH
WEEKDAY
HOUR
WEEKNUM
MINUTE
WORKDAY
MONTH
YEAR
NETWORKDAYS
YEARFRAC
Search JabSto ::




Custom Search