1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel NOW Function

Add the Current Date or Time to an Excel Worksheet

By

Add the Current Date or Time in Excel with the NOW Function

Add the Current Date or Time in Excel with the NOW Function

© Ted French

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 has no arguments. It obtains its information on the current date and time by reading the computer's serial date.

As a result the function continually updates itself every time a worksheet is recalculated.

Normally worksheets recalculate each time they are opened so every day that the worksheet is opened the date will change unless automatic recalculation is turned off.

To enter the date so that it will not change, try using this keyboard shortcut.

Example: Using Excel's NOW Function

For help with this example, see the image above.

  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.

  8. If you want cell D1 to show only the current time or date, change the cell's format to show either time or date only.


Related Tutorials

©2014 About.com. All rights reserved.