Fix an Excel Circular Reference Error Involving TODAY
Question details
Find the source of an Excel circular reference error reported near a TODAY formula.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A workbook uses TODAY() to display or calculate with the current date, and Excel reports a circular reference.
- Observed behavior
- Excel reports a circular reference, but the underlying circular formula may be elsewhere in an open workbook.
Keep the workbooks involved in the calculation open and note the cell containing TODAY(). If you temporarily change a formula during testing, record it so you can restore it afterward.
Find and correct the circular formula in open workbooks
Use Excel's circular reference checker and formula tracing tools to locate the actual loop.
TODAY() is volatile, meaning Excel recalculates it frequently, but TODAY() alone is not a circular reference. A circular reference occurs when a formula refers to its own cell directly or through other formulas.
In each open workbook, select Formulas > Error Checking > Circular References. Select any listed cell address to go to the formula.
Select the reported cell and use Formulas > Trace Precedents or Trace Dependents to follow related cells. Check whether the formula refers back to itself directly or through another formula.
Edit the formula in the formula bar so it refers to the intended input cells rather than its own result. Repeat the circular reference check until no unintended circular references are listed.

Temporarily remove TODAY to isolate the error
Use this test when Excel's reported location does not make the source of the circular reference clear.
Work with spreadsheet formulas in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files in WPS Spreadsheet for an easy transition, though switching apps does not fix an Excel-specific circular reference error.

Frequently Asked Questions
Is TODAY() itself a circular reference?
No. TODAY() is a volatile function, but it does not refer to its own cell. Look for a formula that refers back to its result directly or through other cells.
Where can I find circular references in Excel?
Open each relevant workbook and select Formulas > Error Checking > Circular References. Select a listed address to inspect that cell.
Why did the reported cell change after I removed TODAY()?
Removing a volatile formula can change recalculation and help Excel identify another cell involved in the problem. Check the newly reported formula and restore TODAY() after testing.
Can a circular reference involve another worksheet or workbook?
Yes. A formula can depend on cells across worksheets or workbooks that eventually refer back to it. Keep the relevant workbooks open and inspect the linked formulas.




