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