NOW Function

Syntax

=NOW()

Description

The NOW function returns the current date and time based on the system clock. It is useful for displaying real-time timestamps in a spreadsheet and updating dynamically whenever the worksheet recalculates.

Arguments

• None: The NOW function does not take any arguments.

Return Value

A serial number representing the current date and time according to Excel’s date-time system. The default format displays a readable date and time.

How to Use the NOW Function

Basic Example: Simply enter the formula =NOW() in a cell to display the current date and time.

Formatting: If only the date is needed, format the cell as a date (Ctrl + 1 > Date format). To show only the time, use a time format.

Updating Frequency: The NOW function updates whenever the worksheet recalculates. Press F9 to manually refresh the value.

Use in Calculations: You can add or subtract days/hours from the NOW function:

=NOW() + 1

(Adds one day to the current date/time)

=NOW() - 0.5

(Subtracts 12 hours from the current time)

NOW Function Tips and Tricks

• Prevent Auto-Update: If you want to capture the current date/time without it changing, use Ctrl + ; (for date) and Ctrl + Shift + ; (for time).
• Use in Conditional Formatting: Apply NOW in conditional formatting to highlight expired deadlines or time-based conditions.
• Use in Time Tracking: Combine NOW with other functions like IF and TEXT to track timestamps dynamically.

Additional Resources

• Microsoft Documentation: Microsoft’s Official NOW Documentation