O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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

Working with Date and Time Functions

Using Excel's date and time functions, you can perform worksheet calculations quickly and accurately. For example, if you use your worksheet to calculate your company's monthly payroll, you might use the HOUR function to determine the number of hours worked each day and the WEEKDAY function to determine whether employees should be paid at the standard rate (for Monday through Friday) or at the overtime rate (for Saturdays and Sundays). In this section, you explore a few (but not all) of Excel's date and time functions in detail. For a complete list of functions available in Excel, see Appendix D.

Using the TODAY and NOW Functions

You can enter =TODAY( ) into a cell or a formula to insert the serial value of the ...

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