How to Use NOW in Excel

Key Insights

• The NOW function returns the current date and time as a dynamic value that automatically updates whenever your worksheet recalculates, making it essential for real-time dashboards and time-sensitive calculations
• Unlike static timestamps, NOW is a volatile function that recalculates continuously, which can impact performance in large workbooks—use Ctrl+; and Ctrl+Shift+; for static date/time stamps instead
• Combining NOW with functions like IF, INT, and NETWORKDAYS enables powerful applications like deadline trackers, elapsed time calculators, and business day counters

Introduction to the NOW Function

The NOW function in Excel returns the current date and time as a serial number that Excel can use for calculations. When you enter =NOW() in a cell, Excel displays the current date and time, updating automatically whenever the worksheet recalculates—whether you press F9, edit a cell, or reopen the workbook.

This dynamic behavior makes NOW invaluable for specific scenarios: timestamping data entries, calculating elapsed time since an event, building countdown timers for project deadlines, or creating dashboards that display real-time information. Unlike manually typing dates, NOW ensures your calculations always reflect the current moment.

Here’s what a basic NOW formula looks like:

=NOW()

This returns a value like 1/15/2025 14:32:45, though the exact format depends on your cell formatting settings. Excel stores this as a serial number (45674.6061) where the integer represents days since January 1, 1900, and the decimal represents the time fraction of a 24-hour day.

Syntax and Basic Usage

The NOW function has the simplest syntax in Excel—it requires no arguments:

=NOW()

That’s it. No parameters, no options, just empty parentheses. The function reads your system clock and converts that information into Excel’s date-time serial number format.

The critical characteristic of NOW is its volatile nature. Excel recalculates NOW every time the worksheet updates, which means:

• Opening the workbook triggers recalculation
• Pressing F9 refreshes the value
• Editing any cell causes the entire sheet to recalculate
• Saving the file updates NOW

You can format the NOW result differently depending on your needs:

=NOW()  
// Format as "Short Date": 1/15/2025
// Format as "Long Date": Wednesday, January 15, 2025
// Format as "Time": 2:32:45 PM
// Format as "Custom" (yyyy-mm-dd hh:mm): 2025-01-15 14:32

Right-click the cell, select “Format Cells,” and choose from Date or Time categories, or create custom formats using format codes.

Compare NOW with its sibling function TODAY:

=NOW()      // Returns: 1/15/2025 14:32:45
=TODAY()    // Returns: 1/15/2025

TODAY returns only the date portion (time is set to midnight), making it appropriate when you don’t need hour/minute precision. Both are volatile functions, but TODAY is slightly more efficient since it doesn’t track time components.

Practical Applications and Calculations

NOW shines in real-world scenarios where time matters. Here are battle-tested applications:

Calculating Elapsed Time

Track how long since an event occurred:

// Cell A2 contains: 1/10/2025 9:00 AM
=NOW()-A2
// Result: 5.22916666 (5 days, 5 hours, 30 minutes as decimal)

// Convert to readable format:
=INT(NOW()-A2) & " days, " & HOUR(NOW()-A2) & " hours"
// Result: "5 days, 5 hours"

Deadline Checker

Create status indicators for project deadlines:

// Cell B2 contains deadline: 1/20/2025
=IF(NOW()>B2,"Expired","Active")

// More sophisticated version with warning period:
=IF(NOW()>B2,"EXPIRED",IF(NOW()>B2-3,"WARNING","Active"))
// Shows "WARNING" if within 3 days of deadline

Age Calculator

Calculate someone’s exact age in years:

// Cell A2 contains birthdate: 3/15/1990
=DATEDIF(A2,NOW(),"Y")
// Returns: 34 (years old)

// With months and days:
=DATEDIF(A2,NOW(),"Y") & " years, " & DATEDIF(A2,NOW(),"YM") & " months, " & DATEDIF(A2,NOW(),"MD") & " days"

Service Level Agreement (SLA) Tracker

Monitor if support tickets are within response time:

// A2: Ticket created timestamp
// B2: SLA hours (e.g., 4 hours)
=IF((NOW()-A2)*24>B2,"SLA BREACH","Within SLA")
// Multiplying by 24 converts days to hours

Days Until Event

Countdown to a future date:

// Cell C2 contains: 12/25/2025
=INT(C2-NOW())
// Returns: 344 (days remaining)

// Prevent negative numbers after event passes:
=MAX(0,INT(C2-NOW()))

Common Issues and Best Practices

The volatile nature of NOW creates two primary issues: unwanted recalculation and performance degradation.

Problem: Constant Updates

Every time your worksheet recalculates, NOW updates. This makes it impossible to create permanent timestamps with NOW alone. If you need a static timestamp that doesn’t change, use keyboard shortcuts:

Ctrl+;           // Inserts current date (static)
Ctrl+Shift+;     // Inserts current time (static)
Ctrl+; [Space] Ctrl+Shift+;  // Inserts both date and time (static)

Alternatively, convert a NOW formula to a static value:

1. Select the cell containing =NOW()
2. Press Ctrl+C to copy
3. Right-click and choose “Paste Special”
4. Select “Values” and click OK

The formula disappears, replaced by the static value it returned.

Problem: Performance in Large Workbooks

Each NOW function forces Excel to recalculate whenever anything changes. In a workbook with 100 NOW formulas and complex calculations, this creates noticeable lag. Best practices:

• Limit NOW usage to cells that genuinely need real-time updates
• Use TODAY instead of NOW when time precision isn’t required
• Consider manual calculation mode (Formulas tab → Calculation Options → Manual) for very large workbooks
• Replace NOW with static timestamps for historical records

Formatted Timestamps

Create standardized timestamp formats using TEXT:

=TEXT(NOW(),"yyyy-mm-dd hh:mm:ss")
// Returns: "2025-01-15 14:32:45"

=TEXT(NOW(),"dddd, mmmm dd, yyyy")
// Returns: "Wednesday, January 15, 2025"

=TEXT(NOW(),"hh:mm AM/PM")
// Returns: "02:32 PM"

The TEXT function converts NOW’s serial number to formatted text, which is useful for concatenating timestamps with other text or exporting to systems that expect specific formats.

Advanced Techniques

Combine NOW with other functions to build sophisticated time-based logic:

Business Days Calculations

Calculate working days between a past date and now:

=NETWORKDAYS(A2,NOW())
// Returns business days, excluding weekends

// Include holiday list in range D2:D10:
=NETWORKDAYS(A2,NOW(),D2:D10)

Adding Time Intervals

Schedule future timestamps by adding specific time increments:

=NOW()+TIME(2,30,0)
// Adds 2 hours, 30 minutes to current time

=NOW()+7
// Adds 7 days to current date/time

=NOW()+1/24
// Adds 1 hour (1 day / 24 hours)

Business Hours Calculator

Determine if current time falls within business hours:

// Business hours: 9 AM to 5 PM, Monday-Friday
=AND(WEEKDAY(NOW(),2)<=5,HOUR(NOW())>=9,HOUR(NOW())<17)
// Returns TRUE if currently within business hours

Conditional Formatting with NOW

Highlight rows where deadlines are approaching:

1. Select your data range
2. Conditional Formatting → New Rule → Use a formula
3. Enter: =$C2-NOW()<=3 (deadline in column C, within 3 days)
4. Set formatting (red fill, bold text)

Time-Based Data Validation

Prevent users from entering future dates:

1. Select cells for date entry
2. Data → Data Validation → Custom
3. Formula: =A1<=NOW()
4. Error message: “Cannot enter future dates”

Dynamic Dashboard Timestamp

Create a “Last Updated” indicator:

="Dashboard last updated: " & TEXT(NOW(),"mm/dd/yyyy hh:mm AM/PM")

Place this in a prominent cell, and it automatically shows users when data was last refreshed.

The NOW function is deceptively simple but remarkably powerful when combined with Excel’s broader function library. Use it strategically for real-time calculations, but remember its volatile nature and performance implications. For historical records or high-performance workbooks, static timestamps are often the better choice.