NOW function

The NOW function in Excel returns the current date and time based on your computer’s system clock. It is a dynamic function, meaning it updates automatically every time the worksheet recalculates or when the workbook is opened.

Syntax

NOW()

Parameters

The NOW function does not require any arguments, so it is used simply as NOW().

How It Works

• When you use the NOW function, it returns both the current date and the current time.
• The value returned is in Excel’s date-time serial number format, where the integer part represents the date and the decimal part represents the time.
  • The date is represented as the number of days since January 1, 1900.
  • The time is represented as a fractional part of a 24-hour day (for example, noon is represented as 0.5, 6 AM as 0.25).

Examples

1. Display Current Date and Time: To display the current date and time, use:

   =NOW()
   

   This might return something like 2025-01-13 14:30 (depending on the exact moment the formula is evaluated).

2. Displaying Date Only: If you only want to display the current date (without the time), you can format the cell to display only the date. Use:

   =TODAY()
   

   The TODAY function returns just the current date, without the time.

3. Displaying Time Only: If you want to extract just the time portion, you can subtract the date part. For example:

   =NOW()-INT(NOW())
   

   This formula returns the current time (e.g., 14:30:00).

Common Use Cases

• Dynamic Timestamps: Use the NOW function to create dynamic timestamps that update automatically each time the worksheet is recalculated or the workbook is opened.
• Time Calculations: The NOW function is helpful in scenarios where you need to track the difference between the current time and a specified date/time, such as in project management or for calculating elapsed time.
• Time-based Conditions: It can also be used in formulas that depend on the current date and time, such as determining if a certain event is occurring within a specific time window.

Important Notes

• The NOW function is volatile, meaning it will update automatically every time the worksheet recalculates. This can potentially slow down performance if used excessively in large worksheets.
• The NOW function returns the time based on your system clock, so it will depend on the local time zone of the device where Excel is running.
• The NOW function will always update when the workbook is opened or when any changes are made, making it useful for real-time data tracking.

Summary

The NOW function in Excel provides the current date and time based on your system’s clock, making it useful for dynamic timestamping, time-based calculations, and real-time data tracking. It automatically updates every time the worksheet recalculates, making it ideal for scenarios requiring real-time information.