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)
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
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.
| A | B | |
|---|---|---|
| 1 | Last refreshed | 3/15/2026 2:45 PM |
Example 2 — Just the time of day
Subtract today's date to keep only the decimal part, then format as Time.
Example 3 — Hours until a deadline
Subtracting two date-times gives days; multiply by 24 for hours.
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.

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.