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 ...
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
