Summary

The Excel NOW function returns the current date and time. It gives you a live date-time value that updates when the worksheet recalculates.

NOW is useful for timestamps, elapsed-time calculations, live dashboards, deadline tracking, and any model that needs the current date and current time together.

Syntax

=NOW()

NOW has no arguments. Excel returns the current date and time from the system clock.

Arguments

• None - NOW does not take any inputs.

NOW vs TODAY

Both functions are dynamic, but they return different levels of detail.

If you need hours and minutes, use NOW. If you only care about the day, TODAY is usually simpler.

Using NOW

Excel stores date-times as serial numbers. The whole-number part represents the date and the decimal part represents the time. For example, 0.5 means 12:00 noon.

That makes NOW easy to shift with simple arithmetic. Adding 1/24 moves one hour forward, adding 1 moves one day forward, and subtracting TODAY removes the date portion so only the current time remains.

Microsoft notes that NOW changes when the worksheet recalculates or when a macro containing the function runs. It does not update continuously every second on its own.

Example 1 - Return the Current Date and Time

This is the most direct use of NOW: insert a live timestamp into the worksheet.

=NOW()

This is useful for live dashboards, refresh indicators, and formulas that need the current moment rather than just the current date.

Example 2 - Add One Hour

You can move the current timestamp forward by adding part of a day.

=NOW()+(1/24)

Because one hour is one twenty-fourth of a day, this formula returns the date-time exactly one hour later. The same idea works for minutes and days too.

Example 3 - Keep Only the Time Portion

Subtract TODAY from NOW to remove the date part and keep only the time fraction.

=NOW()-TODAY()

This is helpful when you want to calculate time-of-day values, compare times within the same date, or format the result as a time-only display.

Example 4 - Estimate Seconds Since Midnight

You can convert the current time fraction into seconds by multiplying by the number of seconds in a day.

=(NOW()-TODAY())*86400

This returns the approximate number of seconds that have passed since midnight. It can be useful for diagnostics, logging, and time-based calculations.

Conclusion Recap

• Summary: NOW() returns the current date and time.
• Main use: It provides a live timestamp for time-sensitive formulas.
• Key detail: The decimal part of the result represents the time of day.
• Good for: Timestamps, elapsed time, deadline tracking, and live dashboards.
• Update behavior: It changes when Excel recalculates, not continuously.
• Difference from TODAY: NOW includes the current time, while TODAY does not.