Formula Errors

Fix an Excel Circular Reference Error Involving TODAY

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

Question details

Find the source of an Excel circular reference error reported near a TODAY formula.

Fix an Excel Circular Reference Error Involving TODAY
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.
Before you start

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.

Solution 1Recommended

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.

1
Check for circular references

In each open workbook, select Formulas > Error Checking > Circular References. Select any listed cell address to go to the formula.

2
Inspect formula dependencies

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.

3
Correct the loop

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.

Find and correct the circular formula in open workbooks
Check other workbooks: A circular reference can involve formulas on different worksheets or in different open workbooks. Inspect the formulas and links involved if the reported cell is not the source of the loop.
Free Microsoft Office alternative

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.

Use familiar spreadsheet formulas, including TODAY()Open and edit Microsoft Excel XLSX and XLS filesMove existing spreadsheets into a familiar office interfaceWork with a free, lightweight office suite
QA img-9

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.