Quick Navigation

NOW Function

Excel 2007+

Summary

The Excel NOW function returns the current date and time as a serial number, formatted according to your regional settings. This dynamic function updates automatically when the worksheet recalculates, making it perfect for timestamps, deadline tracking, and time-based calculations.

Syntax

NOW()

Using the NOW Function

NOW() is essential for creating live timestamps and performing calculations based on the present moment. Since Excel stores dates as serial numbers, NOW() returns a single value representing both date (integer portion) and time (decimal portion), enabling powerful date arithmetic.

Common NOW Examples

Get Current Timestamp

=NOW()

Displays the current date and time. Updates whenever the sheet recalculates (F9 or file reopen).

Time 12 Hours Ago

=NOW()-0.5

Subtracts 12 hours (0.5 days) from current time for historical comparisons.

Deadline in 7 Days

=NOW()+7

Adds 7 days to current date - perfect for project timelines.

2 Days and 6 Hours Ago

=NOW()-2.25

Subtracts 2 days and 6 hours (2.25 days total) from now.

Frequently Asked Questions

NOW() updates only when the worksheet recalculates (F9, file open/save, or automatic calculation). This prevents performance issues.

Dates are serial numbers: integer part = days since Jan 1, 1900; decimal = time fraction (0.5 = noon).

NOW() includes time; TODAY() returns only the date portion at midnight.

Common Errors and Solutions

NOW() shows wrong date/time

Cause: System date/time is incorrect

Solution: Check Windows/Mac system clock settings

NOW() not updating

Cause: Manual calculation mode

Solution: Press F9 or go to Formulas > Calculation Options > Automatic

Notes

Format cells as 'General' first - Excel auto-adjusts to regional date/time format
Use Ctrl+Shift+# to apply date formatting quickly
NOW() triggers recalculation in dependent formulas
For static timestamps, press F9 after typing then copy-paste values

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+