Excel Cell Show Current Date? TODAY and NOW Explained

How-to basics · Updated November 19, 2026

To show the current date in an Excel cell, enter =TODAY() and press Enter. To show both the current date and time, use =NOW(); these formulas update when Excel recalculates the workbook, rather than inserting an unchanging date.

Enter TODAY or NOW in a cell

In Excel for Microsoft 365 on Windows, select the cell where you want the date, type the formula, and press Enter. For example, with the date formula entered in A1, that cell displays today’s date according to your computer’s system clock. The formula does not need an argument, and its parentheses must remain even though they are empty.

Use the date-and-time version when a time stamp that can refresh is appropriate. With the formula entered in A1, Excel displays the current date and time according to the computer clock. The displayed time may initially omit seconds or show only the date, depending on the cell’s number format; the underlying value still includes a time fraction.

These formulas are available in Excel for Microsoft 365, including Excel for the web. In Excel for the web, select a cell, enter the formula in the cell or formula bar, and press Enter. The basic formula syntax is the same on Windows, Mac, and the web.

How TODAY and NOW work

Excel stores dates as serial numbers: a whole-number portion represents a day, and a fractional portion can represent a time during that day. The TODAY function returns the current date as a date value, while NOW returns the current date and time as a date-and-time value. They are not simply labels containing words; Excel can use their results in calculations, sorting, and date-based rules.

A key distinction is that these are dynamic formulas. They do not act like a clock that redraws the cell every second or automatically guarantees a change exactly at midnight. Excel refreshes their results when the workbook recalculates. Reopening the workbook or making an edit that triggers calculation will commonly refresh the value, but the precise timing depends on calculation settings and whether Excel has recalculated.

Because TODAY and NOW are volatile functions, Excel recalculates them when calculation occurs, even if their results do not depend on another cell. In a large workbook with many volatile formulas, frequent recalculation can add work for Excel. For an ordinary date label or a modest workbook, this is usually not a concern.

Format the result as a readable date

If a cell displays a number instead of a familiar date, the formula may still be working. Excel may be showing the date’s underlying serial number because the cell is formatted as General or Number. Select the cell, then choose Home > Number Format and select Short Date or Long Date. You can also use the number format menu to choose a date style that suits the sheet.

For a custom display, open the Format Cells dialog with Ctrl+1 on Windows, choose the Number tab, and select Date or Custom. A custom format can show, for example, a weekday and month name while the cell retains its real date value. The exact preview depends on the regional settings and locale used by Excel.

Formatting changes how the value looks, not what the formula calculates. A date shown as 3-Nov-2026 and the same date shown as 11/3/2026 can represent the same underlying day. If a date appears in an unexpected order, check the cell’s date format and your regional settings rather than assuming the formula returned the wrong date.

Choose a live date or a fixed date

Use TODAY when the cell should always represent the current date after recalculation, such as a dashboard heading or a label for a daily report. Use NOW when a live date-and-time value is useful, for example in a worksheet that indicates when it was last recalculated. Neither is suitable when you need a permanent record of the exact date or time an event happened: the value can change later.

For a fixed date entered by hand, select a cell and press Ctrl+; (semicolon) on Windows. That shortcut inserts the current date as a value, not as a TODAY formula, so it will not roll forward tomorrow. To insert the current time as a fixed value, use Ctrl+Shift+; (semicolon). These shortcuts are useful for a log or an entry date that should stay as originally recorded.

On Excel for Mac, the date and time shortcuts can depend on the keyboard and macOS settings. The commonly used equivalents are Control+; for the date and Control+Shift+; for the time. If a shortcut is intercepted by the operating system or does not work with your keyboard layout, type a date or time directly, or check Excel’s shortcut help for your setup. Excel for the web may also handle shortcuts differently depending on the browser and keyboard configuration.

A fixed shortcut is not the same as an automatic timestamp that records when another cell is first filled. TODAY and NOW recalculate, so they are not a reliable way to preserve an entry’s original time. A permanent automatic timestamp generally requires a different workflow, such as a carefully designed macro or an external data-entry process.

Use the date in calculations

A current date formula can support due-date checks, aging lists, and reminders. For example, subtracting an earlier date from today returns the number of days between those dates. With a valid start date in A2 and the day count formula in B2, the formula =TODAY()-A2 returns the elapsed number of days. If A2 contains 1-Nov-2026 and today is 3-Nov-2026, the result is 2. Format the result as General or Number if Excel displays it as a date.

You can also compare a due date with today. With due dates in A2:A20, enter a comparison formula in B2 and fill it down to classify each row. For example, =A2<TODAY() evaluates to TRUE when the date in A2 is earlier than the current date. A blank or text value in the due-date cell may need to be handled separately, because it can produce a result that is not meaningful for your process.

For a countdown, the layout matters: with the target date in A2 and the remaining-days calculation in B2, =A2-TODAY() gives the number of days until that date. A future target produces a positive number; a date that has passed produces a negative number. Decide how to label or display overdue results rather than assuming every result will be positive.

Excel dates must be genuine date values for date arithmetic to work as expected. A date imported as text may look correct but fail to sort or calculate properly. If subtraction gives an error or an implausible result, check whether the source is stored as a date value, and use Excel’s date-conversion tools or re-enter the value in a recognized date format.

Control recalculation when the date seems stale

If TODAY or NOW has not changed when expected, first check whether Excel is recalculating. In Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options and select Automatic. In Manual calculation mode, formula results update only when you request a calculation or otherwise trigger one. This setting applies to the workbook session and can affect more than the date formula.

To recalculate a workbook manually, press F9 on Windows. Shift+F9 recalculates the active worksheet. On some laptops, function-key settings may require pressing Fn as well. On Mac, Excel uses the corresponding calculation shortcuts, which may also depend on the keyboard’s function-key setting; the Formulas tab provides a menu alternative. In Excel for the web, calculation is generally automatic, but a workbook’s calculation settings or a pending recalculation can still affect what you see.

Recalculation uses the computer’s system date and time. If the displayed date is wrong across multiple applications, check the device clock, time zone, and date settings. A worksheet formula does not independently determine the correct local date, and changing the cell’s number format will not fix an incorrect system clock.

Common problems and practical limits

  • The cell shows a serial number: Change the number format to Short Date or another date format; the formula result may already be correct.
  • The date does not update: Check Formulas > Calculation Options and recalculate if the workbook is in Manual mode.
  • The displayed day or month seems reversed: Review the date format and regional settings. Different locales may interpret typed dates differently.
  • The value changes when the workbook is opened later: That is expected for a live TODAY or NOW formula. Use a fixed value for a permanent record.
  • The time is absent: The cell may be formatted to show only a date. Apply a date-and-time format to display the time portion of NOW.

Excel date values do not contain a time-zone identifier. NOW reflects the computer’s clock, so two people in different time zones can see different local times for the same workbook after recalculation. If a team needs a consistent event time, define which time zone the process uses and record an appropriate fixed timestamp or use a system that stores time-zone-aware data.

Frequently Asked Questions

Does TODAY update automatically every day?
It updates when Excel recalculates the workbook, commonly when the workbook opens or changes are made under Automatic calculation. It is not a guarantee that the displayed value will refresh at precisely midnight while the workbook sits open.

What is the difference between TODAY and NOW?
TODAY returns the current date without a time component. NOW returns the current date and time. Both are dynamic formulas and can change when Excel recalculates.

How do I show today’s date without it changing tomorrow?
Use Ctrl+; on Windows to insert a fixed date value. Unlike the TODAY formula, the inserted value stays the same unless someone edits it.

Why does Excel show a number instead of a date?
Excel stores dates numerically, and the cell may be formatted as General or Number. Apply a date number format from Home > Number Format to display the value as a calendar date.

Can I show the current date and time in the same cell?
Yes. Use the NOW function and format the cell with a date-and-time number format. The displayed value will refresh when Excel recalculates, so it is not a permanent timestamp.

Which option should you use?

For a date that should stay current, use TODAY. For a date and time that should stay current, use NOW. For a date or time that records a one-time entry, use the fixed-value keyboard shortcut or enter the value directly. Then apply a suitable number format and check calculation settings if a dynamic result appears stale. Choosing between a live formula and a fixed value is the important decision: they can look alike on screen, but they serve different purposes.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.