Home
MS Office - How to ?
Excel Tutorials
Word Tutorials
PowerPoint Tutorials
Free e-books
VIDEO Tutorials
Office 2007 Guides
Excel 2007 Tutorials
PowerPoint 2007 Guides
Word 2007 Tutorials
MS Office Template
Free Clip Art
Keyboard Shortcut
Tips and Tricks
MS Outlook
MS Publisher
Free Newsletter
MS Windows
Contact Us
Site Map
Google Docs and ...
You and This Site
Resources Page

XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google
 


The Excel NOW Function


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

The syntax for the NOW function is:
= NOW ( )

The NOW function takes no arguments.

To use the Excel 2007 NOW Function:

  • Click on cell C5 - the location where the results will be displayed.
  • Click on the Formulas tab.
  • In the Function Library group, click the Date & Time icon to open the function drop down list.

    date and time formula list


  • Click on NOW in the list to bring up the Function Arguments dialog box. You will see the =NOW() displayed in the cell C5 as well as in the formula bar.

    Excel NOW Function Arguments


  • Click OK.
  • The current time and date should appear in cell C5.
  • When you click on cell C5 the complete function =NOW() appears in the formula bar.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    Recommended book:

    Revealed! 101 Excel Secrets Revealed! 101 Excel Secrets


    You're viewing the Excel NOW Function info page, click here to go back to the Home Page


    footer for excel NOW function page

    		•