• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Formatting and Calculating D... > Working with Date and Time Functions

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, “Function Reference,”

Using the TODAY and NOW Functions

You can enter =TODAY( ) into a cell or a formula to insert the serial value of the current date. If you enter the function into a cell with the General format (which is the default), the resulting value is displayed in mm/dd/yyyy format. Although this function takes no arguments, you must remember to include the empty parentheses. (You'll remember that arguments are variables that supply the values a function needs to perform its calculations. Arguments are placed between the parentheses of functions that require them.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint