Excel TODAY Formula: Show Today’s Date Automatically

Formulas & functions · Updated November 20, 2026

To show today’s date in an Excel cell and have it update, enter =TODAY(). The function returns the current date from Excel’s calculation environment; format the cell as a date if Excel displays a number instead.

What the TODAY function does

TODAY() is a built-in Excel function that returns the current date without needing an argument. The parentheses are required, even though nothing goes between them. In Microsoft Excel for Microsoft 365 on Windows, enter the formula in a worksheet cell and press Enter. Excel displays the date according to that cell’s number format.

The result is a date value, not a piece of text. Excel stores dates as serial numbers so they can be compared, sorted, and used in calculations. The displayed date may look like November 3, 2026, 11/3/2026, or another format, while the underlying value is still usable for date arithmetic. The exact appearance depends on the cell format and, in some cases, regional settings.

TODAY is dynamic: Excel updates its result when the workbook recalculates. It does not act like a clock that visibly changes every second. If you need both the current date and time, use NOW instead.

Enter TODAY in a worksheet

In a blank cell such as A1, enter =TODAY() and press Enter. You do not need to select a date range or supply a cell reference. The formula can be copied to other cells, although the same current date will appear in each one unless other parts of the formulas change.

To add it using the ribbon, select a cell, choose Formulas > Date & Time, select TODAY, and confirm the function in the Function Arguments dialog. Typing the short formula directly is usually quicker. In Excel for the web, type it into a cell in the same way; the web interface differs from desktop Excel in some ribbon details, but the function itself is the same.

Unlike a typed date, the formula keeps referring to the current date as time passes. That makes it useful for dashboards, daily logs, reminders, and reports that are meant to stay current when opened or recalculated. It is not appropriate when the date must remain permanently fixed, such as a dated approval or a historical transaction.

Format the result as a readable date

If the cell shows a number such as 46329 rather than a calendar date, the formula may be working correctly: the cell is likely formatted as General or Number. Select the cell, then choose Home > Number Format (the dropdown in the Number group) > Short Date. Choose Long Date from the same dropdown if you want the weekday and month written out, subject to the formats available in your Excel setup.

You can also open Format Cells to select a date style or create a custom display. On Windows, Ctrl+1 opens Format Cells. The Mac shortcut and some ribbon details can differ by keyboard and Excel version; the Home tab’s number-format controls are an alternative. Formatting changes only how the value appears. It does not turn TODAY into a fixed date or change the underlying date value.

If the cell displays a row of hash marks, commonly shown as #####, the column may be too narrow for the chosen date format. Widen the column by dragging the boundary to the right of its heading, or choose a shorter date format. This is a display issue rather than a problem with the function.

Use today’s date in date calculations

Because TODAY returns a real date value, you can add or subtract days. In a blank cell such as B2, enter =TODAY()+7 to show the date seven days from today. If Excel’s current date is November 3, 2026, this returns November 10, 2026. The result updates as the current date advances, so it always represents a date one week ahead.

For a countdown, assume a target date is stored as an actual Excel date in A2 and enter =A2-TODAY() in B2. If A2 contains November 10, 2026, and the current date is November 3, 2026, the result is 7. A positive result means the target date is in the future; zero means it is today; a negative result means it has passed. Format B2 as General or Number if you want to see the number of days rather than a date.

For elapsed days, put a start date in A2 and enter =TODAY()-A2 in B2. If A2 contains October 20, 2026, and the current date is November 3, 2026, the result is 14 days. These calculations count calendar days, including weekends. They do not automatically account for holidays or business days.

For the last calendar date of the current month, enter =EOMONTH(TODAY(),0) in a blank cell such as C2. On November 3, 2026, it returns November 30, 2026. EOMONTH is useful for month-end summaries and reporting periods; format the result as a date if it appears as a serial number. For a calculation that counts days until month-end, subtract TODAY from that result in another cell.

Choose between a changing date and a fixed date

Use TODAY when the date should reflect the present whenever Excel recalculates. Use a fixed date when the value records what was true at a particular moment. This distinction matters in logs: a TODAY formula entered in a “date created” column will eventually show a later date, so it is not a reliable permanent timestamp by itself.

  • Dynamic date: Enter =TODAY() when a report heading or “days remaining” calculation should stay current.
  • Fixed date in a cell: On Windows, select a cell and press Ctrl+; (Control and semicolon) to insert the current date as a value. It will not update like a formula. Keyboard layouts can affect shortcuts; on Mac, try Control+; or use the available date-entry method for your keyboard.
  • Fixed date from a formula: Copy the formula cell, then use Paste Special > Values to replace the formula with its current result. Check the pasted value before removing any original data.

A formula can show a date that looks fixed today but still change after recalculation tomorrow. To check, select the cell and look at the formula bar: a dynamic cell contains the formula, while a fixed value appears as a date value rather than a TODAY formula.

Common problems and how to fix them

If Excel displays the characters =TODAY() instead of a date, the cell may be formatted as Text, or the formula may have been entered with a leading apostrophe. Change the cell’s format to General, then re-enter the formula. Merely changing the format may not convert text already stored in the cell; selecting the cell, pressing F2, and then Enter can prompt Excel to interpret it again.

If the date does not appear to update, check calculation settings. In Excel for Microsoft 365 on Windows, choose Formulas > Calculation Options > Automatic. With manual calculation selected, formulas may keep old results until a recalculation occurs. Press F9 to recalculate open workbooks on Windows. Excel for Mac has calculation controls too, though shortcuts can differ; Excel for the web generally handles calculation through its online environment.

TODAY can also appear to be one day ahead or behind if the computer or calculation environment has the wrong date or time zone. Check the device’s system date and time, then recalculate. If the workbook is shared, remember that users may see different results when their calculation environments use different current dates. That can affect a report that is expected to show the same date for everyone.

If a date subtraction gives an unexpected result, confirm that the referenced cell contains a real Excel date rather than text that only looks like one. Check the cell’s format and try a consistent date-entry method. Also consider whether the difference is meant to count calendar days or working days; ordinary subtraction counts calendar days.

TODAY versus NOW

TODAY returns the date only. NOW returns the current date and time, which can be useful for a live timestamp display but is still dynamic: it changes when Excel recalculates, rather than permanently recording the moment a row was entered. To display it, enter =NOW() in a blank cell such as A1, then apply a date-and-time format if needed. If the cell shows only a date, its format may be hiding the time portion.

Choose TODAY for date-based comparisons such as “is this due today?” and NOW when the time of day matters. Neither function is, by itself, a permanent record of when a transaction occurred. For an audit trail or entry log, use an appropriate fixed-value process and follow your organization’s record-keeping requirements.

Frequently Asked Questions

What is the Excel formula for today’s date?
In a blank cell such as A1, enter =TODAY(). Excel returns the current date and updates it when the workbook recalculates.

How do I insert today’s date so it will not change?
Select a cell and, in Windows Excel, press Ctrl+; to enter the current date as a fixed value. Unlike the TODAY formula, this entry does not recalculate into a different date tomorrow.

Why does TODAY show a number instead of a date?
Excel stores dates as serial numbers. Select the cell and apply a date format from Home > Number Format > Short Date; the number should display as a calendar date.

Does TODAY include the current time?
No. TODAY returns a date without a time component. In a blank cell such as A1, enter =NOW() for a current date-and-time value, then use a format that displays both.

Why is my TODAY formula not updating?
Excel may be set to manual calculation, or the device’s system date may be incorrect. On Windows, check Formulas > Calculation Options > Automatic, and verify the computer’s date before recalculating.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.