NOW Function

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.

NOW is most useful when the workbook needs a live timestamp rather than a typed static value. That helps with deadline tracking, elapsed-time checks, and dashboards that should reflect the current moment automatically. Because the function updates when Excel recalculates, it is powerful but also more dynamic than a fixed timestamp entered by hand.

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

NOW is useful when a workbook needs the current moment, not just today’s date. This lesson used it for live timestamps, adding time to the present moment, pulling out the time-only part, and estimating how many seconds have passed since midnight.

The important habit is remembering that NOW is dynamic. It changes when Excel recalculates, so it is great for live formulas, but not for permanent stamped times unless you handle that another way.

• 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.