Excel’s NOW() function does update, but it does not run like a live clock: it returns the current date and time when Excel recalculates the worksheet, not once every second. If the result appears stuck, check the workbook’s calculation mode, force a recalculation, and confirm the cell is formatted to show the time.
How Excel NOW works
NOW() is a volatile function. That means Excel recalculates it whenever a calculation event occurs, even if the cells it refers to have not changed. It takes no arguments and uses the date and time from the computer running Excel. The value is stored as a date-time number; what you see depends on the cell’s number format.
With a blank worksheet and the formula entered in A1, the cell returns the current date and time when Excel calculates it. The result is not a continuously advancing clock reading. For example, if the workbook recalculates at 10:15:00 and you look again at 10:15:20 without anything triggering calculation, A1 may still show 10:15:00. After a recalculation, it should show the new time.
Volatility also means the value can change after an edit that has nothing to do with the cell containing NOW. In Automatic calculation mode, editing another cell generally causes Excel to recalculate formulas, including volatile ones. This is useful for a “last refreshed” display, but it is not suitable when you need an unchanging record of when an event happened.
First, force a recalculation
To check whether calculation is the issue, recalculate the worksheet or workbook. In Excel for Microsoft 365 on Windows, press F9 to calculate formulas in open workbooks, or press Shift+F9 to calculate the active worksheet. If ordinary recalculation does not refresh a result that appears stale, Ctrl+Alt+F9 forces a full calculation of all formulas. These shortcuts may require the Fn key on laptops where the function keys control hardware features.
On a Mac, use the Formulas tab and choose Calculate Now or Calculate Sheet rather than assuming a Windows F-key shortcut applies. Keyboard behavior can depend on the Mac’s function-key settings and keyboard. Excel for the web also has calculation commands on the Formulas tab, though the available controls can vary with the workbook and current web interface.
For a quick test, note the displayed time, wait briefly, and trigger Calculate Now. If the time changes, the formula is working; it simply was not being recalculated automatically. If it does not, continue with the checks below.
Check the workbook’s calculation mode
In Excel for Microsoft 365 on Windows, select Formulas > Calculation Options > Automatic. In Automatic mode, Excel recalculates dependent formulas when relevant inputs change and refreshes volatile functions during calculation. A workbook in Manual mode does not recalculate after each edit, so NOW can remain at its previous calculated value until you request a calculation.
Calculation mode is a common source of confusion because it is a workbook-level setting that can affect other open workbooks. If one workbook was opened with Manual calculation selected, Excel may continue using that mode while you work. Check the setting rather than assuming that a newly opened workbook is necessarily recalculating automatically.
Manual mode is sometimes intentional. Large workbooks with extensive formulas may calculate slowly, so someone may switch to Manual to make editing faster. If you change the setting to Automatic, Excel can begin recalculating many formulas and performance may feel slower. If you need Manual mode for performance, use Calculate Now when you want the displayed time refreshed, and remember that other formula results may also be waiting for calculation.
Make sure the cell displays the time
A cell can contain a current date-time value while appearing not to update because its number format hides the part that changed. For example, a cell formatted to show only a date will look identical throughout the day even as the time advances. A format that shows hours and minutes but not seconds can also hide changes that happen within the same minute.
Select the result cell and use Home > Number Format to choose a date-and-time format. For more control, press Ctrl+1 on Windows to open Format Cells, select Custom, and enter a format such as yyyy-mm-dd h:mm:ss. On a Mac, open Format Cells from the Format menu or the Home tab; the exact dialog presentation can differ. Formatting changes how a value appears, not when Excel recalculates it.
Also check that the column is wide enough to show the formatted value. A row of number signs usually indicates that the column is too narrow for the selected number format. Widen the column or choose a shorter format. If you see only a date, a number, or a truncated display, changing the format is a better first step than replacing the formula.
Confirm the cell contains a working formula
Click the cell and look at the formula bar. If the entry is displayed as text, Excel will not calculate it. This can happen if the cell was formatted as Text before the formula was entered, or if an apostrophe was typed before the equals sign. Change the cell’s format to General, then re-enter the formula and press Enter. Merely changing Text to General may not convert an existing text entry into a formula; re-entering it is important.
Make sure the entry begins with an equals sign and is spelled correctly. The function has no arguments, so extra text inside the parentheses is not needed. If Show Formulas is enabled, Excel displays formulas in cells instead of their results; toggle it from Formulas > Show Formulas or press Ctrl+` on Windows. On a Mac, use the Show Formulas control on the Formulas tab if the keyboard shortcut differs.
With the formula entered in A1, the expected formula is =NOW(). Its result is the current date and time at the most recent calculation; the exact displayed value depends on the computer clock, calculation timing, and cell format. If the formula bar shows this expression but the visible value seems old, calculation mode and display formatting are the next things to inspect.
Why NOW does not refresh every second
NOW is not a timer and does not schedule a recalculation at a fixed interval. Excel recalculates formulas in response to calculation events, such as edits in Automatic mode, opening or recalculating a workbook, or a manual calculation command. It does not keep updating a cell every second simply because the formula is present.
This distinction matters for dashboards. A NOW cell may refresh when a user edits an unrelated input, then remain unchanged while the workbook sits idle. A volatile function can be refreshed as part of calculation, but volatility does not mean continuous updating. If a workbook must display a clock that advances at regular intervals, a formula alone is not a dependable mechanism for that requirement. Automated approaches may involve macros or other tools, which bring security, compatibility, and maintenance considerations.
NOW also uses the local system date and time. If the computer clock or time zone is incorrect, the displayed value can be incorrect even when Excel is calculating normally. Excel does not independently verify the time against an internet time service through this function. Correct the computer’s date, time, and time-zone settings if the value itself is wrong.
NOW versus a fixed timestamp
A frequent misconception is that NOW creates a permanent timestamp when first entered. It does not: it is a formula, so it can change with later recalculations. If a record needs to preserve the moment an order was received, a status changed, or a task was completed, use a fixed timestamp instead of relying on NOW as an audit trail.
For a one-time manual entry on Windows, Ctrl+; inserts the current date as a value, while Ctrl+Shift+; inserts the current time as a value. These entries do not update like formulas. If you need both date and time, insert them in the same cell using the applicable shortcuts, or enter them in separate cells and label them clearly. On a Mac, shortcut mappings can differ; use the Insert menu’s date or time options where available, or consult Excel’s shortcut list for the installed version and keyboard.
A fixed entry is useful for a simple manual log, but it is not automatically tied to an event. Typing over a timestamp, sorting rows without keeping related fields together, or relying on users to remember the shortcut can undermine the record. For processes that require dependable history, consider a controlled data-entry workflow, version history, or an appropriately designed automated solution. A volatile formula is a display of the latest calculation time, not proof of when a business event occurred.
Common symptoms and practical fixes
- The time changes only after pressing F9: Check Formulas > Calculation Options > Automatic. If Manual mode is intentional, recalculate when you need an updated value.
- The date changes but the time seems frozen: Apply a format that includes hours, minutes, and, if needed, seconds. A date-only format hides time changes.
- The cell shows the formula itself: Check Show Formulas, Text formatting, and any leading apostrophe. Re-enter the formula after correcting the cell format.
- The result is an unexpected time: Check the computer’s clock and time zone, then recalculate. NOW reflects the local system time available to Excel.
- The workbook becomes slow after switching to Automatic: The workbook may contain many formulas. Allow recalculation to finish, or use Manual mode deliberately and calculate when needed.
- The formula changes when another cell is edited: That is expected behavior for a volatile function during recalculation. Use a fixed timestamp if the value must stay unchanged.
Frequently Asked Questions
Does Excel NOW update automatically?
It updates when Excel recalculates the workbook or worksheet, including during automatic calculation after edits. It does not refresh continuously or tick forward every second while the workbook is idle.
How do I make NOW update immediately?
Use F9 on Windows to calculate open workbooks or Shift+F9 to calculate the active sheet. You can also choose Calculate Now or Calculate Sheet on the Formulas tab. If the value remains stale after that, check the formula, calculation mode, and number format.
Why does my NOW formula show only the date?
The cell is probably formatted to display a date without a time. Select a date-and-time number format, or use Format Cells to apply a custom format that includes hours and minutes.
Can NOW update every second without pressing a key?
Not by itself. NOW recalculates when Excel performs a calculation; it does not set a recurring one-second timer. A live clock requires a different approach, and any macro-based solution needs careful handling of security and workbook compatibility.
How do I keep a timestamp from changing?
Use a fixed date or time value rather than a NOW formula. On Windows, Ctrl+; inserts the current date and Ctrl+Shift+; inserts the current time as values. For a process that must preserve reliable event history, use a controlled logging method rather than relying on a volatile formula.
Related
- Data Cleaning Shortcuts in Excel: A Practical Guide
- Excel to PowerPoint Link: How to Keep Slides Updated
- Excel to PowerPoint Linked Cells: How to Link and Update
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel COUNTIF Examples for Text, Dates, and NumbersExcel’s COUNTIF function counts cells in a range that match one condition. Its syntax is =COUNTIF(range,criteria); for example,…
- Excel Date Difference: Formulas for Days, Months & YearsTo find the number of days between two dates in Excel, subtract the earlier date from the later…
- How to Find the Sum of a Column in Excel With a FormulaTo find the sum of a column in Excel, enter a SUM formula such as =SUM(A2:A20) in an…
- Excel Year Quarter Formula: Get Year and Quarter from DatesWith a valid Excel date in A2, use =ROUNDUP(MONTH(A2)/3,0) to return its calendar quarter as a number from…
- Is INDIRECT Volatile in Excel? Performance ExplainedYes. INDIRECT is a volatile Excel function, so it recalculates whenever Excel recalculates, even when the cells named…
- XLOOKUP Excel Cell References: A Practical GuideIn Excel, an XLOOKUP cell reference is the cell or range you tell the function to search or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.