Excel 2007 NOW Function

Add Today's Date and/or Time to an Excel Spreadsheet

Related article: Date Functions in Excel 2003.

The NOW function, one of Excel's date and time functions, is used to add the current time and date to a spreadsheet.

The syntax for the NOW function is:

= NOW ( )

Note: The NOW function takes no arguments.

Example Using Excel's NOW Function:

Note: For help with this example, see the image to the right.

1. Click on cell D1 - the location where the results will be displayed.
   
   
2. Click on the Formulas tab.
   
   
3. Choose Date & Time from the ribbon to open the function drop down list.
   
   
4. Click on NOW in the list to bring up the function's dialog box.
   
   
5. Click OK.
   
   
6. The current time and date should appear in cell D1.
   
   
7. When you click on cell D1 the complete function = NOW ( ) appears in the formula bar above the worksheet.

• Excel 2007 TODAY Function
• Keyboard Shortcuts - Adding the Current Date in Excel
• Date Functions in Excel 2003