Shortcut Key for Yesterday’s Date in Excel: What Works

Shortcut Key for Yesterday's Date in Excel: What Works

Excel does not have a dedicated keyboard shortcut that inserts yesterday’s date. In Excel for Microsoft 365 on Windows, Ctrl+; inserts today’s date as a fixed value; to get yesterday, enter a date formula instead, or calculate it and convert the result to a fixed value.

Is there a direct shortcut for yesterday’s date?

No built-in shortcut inserts yesterday’s date in one action. The date shortcut inserts the current date, not a date one day earlier. That difference matters: pressing Ctrl+; is useful when today is what you want, but it will not automatically subtract a day or adapt to a request for yesterday.

If you want yesterday’s date in a cell, the simplest method is to enter a formula in that cell. With the desired result in A1, enter =TODAY()-1. The formula returns the date one day before the date Excel uses as today. For example, if Excel evaluates today as November 3, 2026, the result is November 2, 2026. The cell may need date formatting to display the result as a familiar calendar date.

This is a formula rather than a keyboard shortcut, but it is usually faster and less error-prone than working backward from today by hand. It also avoids confusion around dates near the start of a month, year, or leap year, because Excel handles the date arithmetic.

How the date formula works

Excel stores dates as numbers and treats each whole-number step as one day. The TODAY function returns the current date according to Excel’s calculation, and subtracting one moves the result back by one day. This arithmetic works across month and year boundaries: if today is March 1, subtracting one returns the last day of February, including February 29 in a leap year.

The formula is dynamic. It does not permanently record the date that was yesterday when you first entered it. When the workbook recalculates on a later day, the result moves forward so it continues to show the day before the current date. That behavior is useful for a live dashboard or a report that should always refer to the latest completed day, but it may be unsuitable for a dated log or record that must not change.

TODAY does not update continuously like a clock. Excel updates it when the workbook recalculates, such as when the file is opened or a calculation occurs. In the usual automatic calculation mode, the value will refresh as part of normal workbook use. A workbook set to manual calculation may not refresh until calculation is requested.

Using the current-date shortcut and keeping a fixed result

On Windows, select a cell and press Ctrl+; to insert today’s date as a fixed value. The inserted date will not roll forward tomorrow. This is different from entering a formula: the shortcut places a date value in the cell rather than a live calculation.

If you need a fixed value for yesterday, enter the formula first and then replace the formula with its calculated result. One straightforward workflow is:

Enter the yesterday formula in the cell where the date should appear.
Copy that cell.
Use Home > Paste > Paste Values to replace the formula with its current result.
Check that the cell still displays a date and no longer changes after a later recalculation.

Paste Values keeps the displayed result but removes the formula. This is helpful for a daily close report, a dated note, or a record of when a process took place. If you only want a date that updates automatically, leave the formula in place. Before converting it, be sure that a fixed date is really what the workbook needs.

Choosing between a dynamic date and a fixed date

The right approach depends on what the date means in your sheet. A dynamic result is appropriate when the question is always “What was yesterday?” For example, a status page might show the latest complete day’s sales, and the date should update automatically each morning. A fixed value is preferable when the date is part of a historical record, because an old entry should continue to identify the same day.

Use the formula for dashboards, recurring summaries, or worksheets that need to refer to yesterday without daily editing.
Use a fixed value for an archived report, a transaction log, or a dated entry that must remain unchanged.
Use Ctrl+; when the date you want to enter is today, not yesterday.

A common misconception is that a formula showing yesterday is automatically a historical timestamp. It is not: the formula keeps recalculating. If the workbook is opened next week, it will show the day before that week’s current date unless you have converted it to a value. For records that need both a date and a time, use a suitable timestamp method and confirm whether it should be fixed or recalculating; a date-only formula does not capture the time an event happened.

Displaying the result as a readable date

A correct calculation can look like an unexpected number because Excel stores dates numerically. If A1 shows a number rather than a calendar date, select the cell and choose Home > Number Format > Short Date. The exact visible style depends on regional settings, so the same date may appear in month-day-year or day-month-year order. That difference is usually display formatting, not a different result.

You can choose a longer or custom date display from the Number Format controls if the worksheet needs a month name or a particular layout. Formatting changes how the date appears; it does not change the underlying date value. This means the cell can still be used in date calculations, sorting, and filters after you change its appearance.

If the cell displays a row of number signs, the column may simply be too narrow for the selected format. Widen the column or choose a shorter date format. If it displays text that looks like a date, Excel may not recognize it as a true date value. That can happen when dates are imported or entered in a format that conflicts with regional settings, and text dates may not behave properly in date arithmetic.

Windows, Mac, and Excel for the web

For Excel for Microsoft 365 on Windows, Ctrl+; inserts today’s date. On Excel for Mac, the corresponding current-date shortcut is Control+; on supported keyboard layouts; it is not generally Command+;. Keyboard layouts can place punctuation differently, so if the semicolon combination is awkward, use the formula method or check Excel’s keyboard-shortcut help for the active layout.

The important limitation is the same on Windows and Mac: the shortcut inserts today, not yesterday. The formula approach works across the desktop versions that support TODAY, including Microsoft 365. In Excel for the web, keyboard behavior can depend on the browser and keyboard layout. If the shortcut does not produce the expected result, type the formula into the cell instead; it is the more dependable way to calculate yesterday.

Do not confuse the current-date shortcut with the current-time shortcut. Excel has separate keyboard commands for date and time. If a cell needs only yesterday’s calendar date, use the date calculation and format it as a date rather than relying on a time-entry command.

Common problems and how to fix them

If the result seems to be today rather than yesterday, check that you entered the subtraction after the date function and that the cell contains a formula, not a date inserted by Ctrl+;. If a formula appears literally in the cell, 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 re-enter the formula.

If yesterday does not update, check the workbook’s calculation mode. In Excel for Windows, choose Formulas > Calculation Options > Automatic. In manual mode, Excel can leave a previously calculated result on screen until the workbook recalculates. A calculation setting can apply across the Excel session, so take care when changing it in a workbook used by other people.

If the date is off by one day, verify the computer’s date and time settings and check whether the workbook uses formulas or imported text. Excel’s TODAY function follows the system date available to Excel; it does not determine the date from a business calendar or a particular time zone rule. If the workbook is used across regions or time zones, decide which local date the report is meant to represent and use a consistent source for that date.

When a different method makes more sense

For a one-time entry, typing the date directly may be the clearest option, especially if you have already confirmed the calendar date. For repeated reporting, a formula saves daily editing. For a record that must stay fixed but is calculated from today, the formula-then-Paste-Values workflow gives you the calculated date without leaving a live formula.

If a worksheet uses a date selector or receives dates from another system, use that source rather than adding a separate calculation that could disagree with it. For example, a report based on the last business day may need to account for weekends and holidays; simply subtracting one calendar day will return Saturday when today is Sunday. The yesterday formula means the previous calendar date, not the previous working day. A business-day requirement needs a different rule and a holiday calendar where applicable.

Frequently Asked Questions

What is the shortcut to insert today’s date in Excel?
In Excel for Microsoft 365 on Windows, select a cell and press Ctrl+;. Excel inserts today’s date as a fixed value. On Mac, use Control+; on a supported layout.

Can I insert yesterday’s date with Ctrl+;?
No. That shortcut inserts today’s date. To calculate yesterday, use the date formula described above. Convert its result to a value if the date must remain fixed.

Will the yesterday formula change tomorrow?
Yes. It recalculates to remain one day before the current date Excel recognizes. Copy the cell and use Paste Values if you need to preserve the current result.

Why does Excel show a number instead of a date?
Excel may be displaying the underlying date serial number. Apply Home > Number Format > Short Date, or choose another date format that suits the worksheet.

Does subtracting one give the previous business day?
No. It gives the previous calendar day, which could be a weekend or holiday. A previous-business-day result requires a workday rule and, where relevant, a list of holidays.

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.