Excel: Now Function

In Excel, the Now function returns the current system date and time. This function will refresh the date/time value whenever the worksheet recalculates.

The syntax for the Now function is:

Now()

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

The spreadsheet will continue to display this value, until the worksheet recalculates. By pressing the F9 key, you can force the worksheet to recalculate and the NOW function will update its value.

VBA Code

The Now function can also be used in VBA code. For example:

Dim LValue As Date

LValue = Now

In this example, the variable called LValue would now contain the current system date and time.