"Excel NOW Function - Guide to Use the NOW Function in Excel 2007"

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 worksheet/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.

• 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.

• 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.

Related Topics:

How to Write a Formula in Microsoft Excel 2007?
Knowing the Different Types of Excel 2007 Functions
Using Excel 2007 IF Function to Perform the Calculation That Can Ease Your Daily Related Tasks
How to Use the Cell Function in Microsoft Excel 2007?
Demonstration of Using the Date and Time Functions with Excel 2007
Use the Microsoft Excel 2007 Product Function to Perform the Calculation
Use the Excel 2007 MAX Function to Find a Largest Number in a Series
Using the Excel 2007 Count Function - Example Demonstration
Guide to Use the Excel 2007 Radian Function Correctly

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

Custom Search

Back to Top

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

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb