Microsoft Excel Date Today: TODAY Formula and Useful Tips

Formulas & functions · Updated November 20, 2026

To show today’s date in Microsoft Excel for Microsoft 365 on Windows, enter =TODAY() in a cell and press Enter. Excel returns the current date and updates it when the workbook recalculates; to enter a date that will stay fixed, use the keyboard shortcut Ctrl+; instead.

What the TODAY function does

TODAY() is a built-in Excel function that returns the current date according to the date and time settings available to Excel. It has no arguments, so the parentheses stay empty. If the computer’s date is November 3, 2026, for example, a cell containing the function displays November 3, 2026, subject to the cell’s number format.

The returned value is a real Excel date, not merely a piece of text. Excel represents dates as serial numbers and uses number formatting to display those numbers as calendar dates. That is why a TODAY result can be used in date arithmetic, sorted chronologically, or compared with another date. It also explains why changing a cell’s format can make a date appear as a number without changing the underlying value.

TODAY does not run like a clock that refreshes the cell continuously. Its value changes when Excel recalculates the formula, such as when the workbook opens or a relevant calculation occurs. It is therefore useful for a live report date, a deadline tracker, or a worksheet that should reflect the current day, but it is not suitable for recording the exact date on which a particular action occurred unless you deliberately preserve the value.

How to enter the formula

In a blank cell, type =TODAY() and press Enter. The cell should show a date. If Excel displays a number or an unexpected date style, the formula may still be working; adjust the number format as explained below. To put the current date in a heading, you can also enter the formula in a cell and refer to that cell from the heading or report, rather than typing the date by hand each day.

For example, with no other cell references needed, entering =TODAY() in A1 on November 3, 2026, returns November 3, 2026. The precise displayed style depends on A1’s format and regional settings. The underlying date remains available for calculations even if the cell is formatted to show only the weekday or month.

On Excel for Mac, the function name and formula work the same way. Excel for the web also supports TODAY. For a date that should not change, the shortcut on Windows is Ctrl+; (Control and semicolon). In Excel for Mac, use Control+; as well; keyboard layouts can affect how the semicolon key is entered. In the web version, shortcut behavior can depend on the browser and keyboard layout, so typing the date or using the desktop app may be more dependable if the shortcut is intercepted.

Format the date so it is easy to read

Excel may apply a default date format, but you can choose a different display without changing the value. Select the cell, then use Home > Number Format and choose Short Date or Long Date. Short Date commonly displays a compact numeric date, while Long Date includes the weekday and spells out the month; the exact appearance varies by regional settings.

For more control, open the Format Cells dialog with Ctrl+1 on Windows, choose the Number tab, and select Date or Custom. A custom format such as mmmm d, yyyy displays a date like November 3, 2026; ddd, mmm d displays a compact weekday and month style such as Tue, Nov 3. These formats affect presentation, not the underlying date. On Mac, Command+1 opens Format Cells in Excel; the number-format choices are also available from the Home tab.

If you want a date written out as text by a formula, TEXT can apply a format to TODAY’s result. With the formula entered in A1 and the computer date set to November 3, 2026, enter =TEXT(TODAY(),"dddd, mmmm d, yyyy") in B1 to return the text Tuesday, November 3, 2026. Because the result is text, it is less convenient for date calculations and chronological sorting than a real date. Prefer normal cell formatting when the value needs to remain usable as a date.

Automatic date or fixed date?

The key choice is whether the cell should keep updating. TODAY is appropriate when “today” should always mean the date at the time Excel recalculates. A fixed date is better for a transaction log, a sign-off, a dated note, or a record of when a task was completed. In those cases, a live formula could silently change the historical information later.

  • Use TODAY() for a report’s current date, days remaining until a deadline, or a dashboard that should stay current.
  • Use Ctrl+; to insert today’s date as a fixed value in the selected cell on Windows or Mac. Unlike a formula, it will not update tomorrow.
  • Type a date directly when you need to record a specific past or future date. Enter it in a form Excel recognizes for your regional settings, then confirm it is interpreted as a date rather than text.

Do not confuse the date shortcut with the current-time shortcut. On Windows, Ctrl+Shift+; inserts the current time as a fixed value. If you need a changing date and time in a cell instead, use NOW(), which returns both a date and a time and recalculates. TODAY returns a date only; its displayed value does not include the current time.

Use today’s date in calculations

A live date becomes more useful when compared with another date. Suppose a worksheet lists due dates in column A, with the first due date in A2. In B2, enter =A2-TODAY(). If A2 contains November 10, 2026, and the current date is November 3, 2026, the result is 7, meaning seven days remain. Format the result as a number rather than a date, because the subtraction returns a count of days.

If the due date is today, the same subtraction returns 0; if the due date has passed, it returns a negative number. That makes the calculation useful for distinguishing upcoming and overdue items. It does not by itself label a task as overdue or account for business days, holidays, or a rule that deadlines move when they land on weekends. Those requirements need their own logic and, where necessary, a suitable workday calculation.

You can also compare an entered date to today in a conditional formula or use the result in a chart or summary. Be aware that any result based on TODAY can change after recalculation. If a report must preserve the exact date and calculations as they stood when it was issued, consider copying the relevant results and using Paste Special > Values, or save a dated copy of the workbook.

When Excel recalculates TODAY

Excel normally uses automatic calculation, so formulas update as you work and when a workbook opens. To check the setting in Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options and select Automatic. If calculation is set to Manual, TODAY may continue to show an older result until you request a calculation. Press F9 to recalculate open workbooks; on some Mac keyboards, you may need to press Fn+F9.

Changing a workbook’s calculation setting can affect every formula in that workbook, not just TODAY. If a date appears stale, first confirm the computer’s system date and the calculation mode. Re-entering the formula is usually unnecessary. On opening a workbook created in another application or with different calculation settings, Excel may also prompt or recalculate formulas according to the workbook’s settings.

Common problems and their causes

If the cell displays a serial number, apply a date format. If it shows #NAME?, check that the function is spelled TODAY and that the formula begins with an equals sign. If the cell shows the literal characters =TODAY() instead of calculating, the cell may be formatted as Text, or the entry may have been preceded by an apostrophe. Change the format to General or Date, then edit the cell and press Enter again.

Regional settings can affect how dates typed directly into a worksheet are interpreted. For example, a short date with day and month both at 12 or below can be ambiguous across regions. Excel’s TODAY result avoids that particular input ambiguity, but display conventions still vary. When exchanging a workbook, use a clear date format with a four-digit year and verify that imported date columns are actual date values rather than text.

Another common misunderstanding is that TODAY freezes the date when the formula is first entered. It does not: it is designed to recalculate. Conversely, Ctrl+; inserts a fixed date and will not roll forward. Choose based on the purpose of the cell, not just on which method is quicker to enter.

Excel date systems and workbook compatibility

Excel’s stored date values make date arithmetic possible, but workbooks can use different date systems. Most Windows workbooks use the 1900 date system. Excel also supports a 1904 date system, historically used by some Mac workbooks. For the same calendar date, serial values in these systems differ by 1,462 days. Excel can account for date-system settings when working within a workbook, but copying raw serial values between workbooks that use different systems can produce dates that appear shifted.

If dates change unexpectedly after copying or importing data, check whether the source and destination workbooks use different date systems and whether the copied cells are genuine dates. Avoid manually adjusting serial numbers unless you understand the source and destination settings. For everyday use of TODAY in a single workbook, the difference is usually invisible; it matters most when moving date values between certain older or specially configured files.

Frequently Asked Questions

What is the Excel formula for today’s date?
Enter =TODAY() in a cell. It returns the current date and updates when Excel recalculates the workbook.

How do I insert today’s date without it changing?
On Windows, select a cell and press Ctrl+; (Control and semicolon). Excel inserts a fixed date value. Excel for Mac uses Control+; too, though the key combination can vary with keyboard layout.

Why is Excel showing a number instead of a date?
The value may be displayed in General or Number format. Select the cell and choose a date format from Home > Number Format. Excel stores dates as numbers, so the displayed number does not necessarily mean the formula failed.

Does TODAY update every second?
No. TODAY returns a date, not a running clock, and updates when Excel recalculates. Use NOW if you need a recalculating date-and-time value; use the fixed date and time shortcuts if you need an entry that will not change.

How do I show today’s date in a different format?
Select the formula cell and choose a format from Home > Number Format, or open Format Cells with Ctrl+1 on Windows. Formatting changes how the date looks, not its stored date value.

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.