NOW Function

Returns the current date and time.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

The current date and time (serial number)

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

Overview

NOW returns today's date plus the current time. The whole number is the date and the decimal part is the time of day (0.5 is noon).

Like TODAY it's volatile and takes no arguments, and it only updates when the workbook recalculates — it isn't a live clock.

Syntax

=NOW() Explain

This function takes no arguments — the brackets stay empty.

Examples

Example 1 — "Last refreshed" stamp on a report

Show when the figures were last calculated. Format the cell as m/d/yyyy h:mm AM/PM.

AB
1Last refreshed3/15/2026 2:45 PM
=NOW() Explain

Example 2 — Just the time of day

Subtract today's date to keep only the decimal part, then format as Time.

=NOW()-TODAY() Explain

Example 3 — Hours until a deadline

Subtracting two date-times gives days; multiply by 24 for hours.

=(B2-NOW())*24 Explain

Common mistakes

  • Comparing NOW with a date. NOW includes the time, so =A2=NOW() is almost never TRUE. Compare with TODAY() for date-only checks.
  • Recalculation slows a big workbook. Every NOW and TODAY recalculates on every change. Keep one in a single cell and refer to it.

Notes

  • To stamp a fixed date and time, press Ctrl + ;, a space, then Ctrl + Shift + ;.
  • Related functions: TODAY, TIME, HOUR, MINUTE.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.