The fastest way to change a date in Excel

To change a date in Excel, click the cell containing the date, type the new date in the format Excel recognizes (such as 1/15/2024 or January 15, 2024), and press Enter. Excel will automatically format it as a date. If you want to change multiple dates at once or adjust dates by a set number of days, you can use formulas or the Find & Replace feature instead.

The method you choose depends on whether you are editing one cell, a range of cells, or dates that need a consistent adjustment. Each approach takes less than a minute once you know where to look.

Key Takeaways

  • Clicking a cell and typing a new date, then pressing Enter, is the simplest way to change a single date in Excel.
  • Excel recognizes dates in common formats like 1/15/2024, 01/15/2024, and January 15, 2024, and will format them automatically.
  • Use Find & Replace (Ctrl+H on Windows, Command+H on Mac) to change all instances of one date to another across your entire sheet.
  • A formula like =A1+7 will add days to an existing date, letting you adjust multiple dates by the same amount without retyping each one.
  • If Excel displays your new date as a number like 45000, you need to format the cell as a date rather than a number.

Editing a single date by typing

Click the cell that holds the date you want to change. You will see the date appear both in the cell and in the formula bar at the top of the screen. Type the new date using any standard format—1/15/2024, 01-15-2024, or January 15, 2024 all work. Excel recognizes these patterns and will store the entry as a date.

Press Enter when you finish typing. Excel will move to the next cell down and keep your new date in the cell you edited. The date will appear in whatever format was already applied to that cell. If you want to change the format (for example, to show the full month name instead of a number), right-click the cell, select Format Cells, choose the Date category, and pick a format from the list.

Changing multiple dates using Find & Replace

If you need to change the same date everywhere it appears in your sheet, use Find & Replace. Press Ctrl+H on Windows or Command+H on Mac. A dialog box will open with two fields: Find and Replace With.

Type the date you want to find in the Find field (for example, 1/15/2024). Type the new date in the Replace With field. Click Replace All to change every instance at once, or click Find Next and then Replace to change one at a time and review each change. Click Close when you are done. This method is much faster than clicking each cell individually if you have dozens of dates to update.

Adding or subtracting days from multiple dates

If you need to shift a group of dates forward or backward by the same number of days—for example, moving all project important date ahead by one week—use a formula instead of retyping. Click an empty column next to your dates. In the first cell of that column, type =A1+7 (if your dates are in column A and you want to add 7 days). Press Enter.

Click the cell with your formula. You will see a small square in the bottom-right corner of the cell. Click and drag that square down to copy the formula to all the rows that contain dates. Excel will automatically adjust the cell reference for each row (A1 becomes A2, A3, and so on). The new column will now show each original date plus 7 days. To subtract days instead, use a minus sign: =A1-7.

Once you have the adjusted dates in the new column, you can copy them and paste them back into the original column if you want. Click the column with your new dates, press Ctrl+C to copy, then click the original date column and press Ctrl+V to paste. A menu will appear asking what you want to paste—select Paste Special, then choose Values Only so that only the dates are pasted, not the formulas.

Fixing dates that appear as numbers

Sometimes when you type or paste a date, Excel displays it as a long number like 45000 instead of a date. This happens because the cell is formatted as a number rather than a date. To fix it, right-click the cell and select Format Cells. In the dialog that opens, click the Number tab if it is not already selected. On the left side, click Date. Choose a date format from the list on the right and click OK.

Your number will now display as a proper date. If the date still looks wrong after formatting (for example, the month and day are reversed), the issue is usually that Excel misread the format you typed. Delete the content, type the date again using a clearer format like January 15, 2024 or 01/15/2024, and press Enter.

Changing dates in a table or named range

If your dates are part of an Excel table (created with Insert > Table), the same editing methods work—click the cell, type the new date, and press Enter. Tables do not require special steps. However, if you have named a range of dates (for example, "Project_Dates"), you can still edit individual cells within that range the same way.

If you need to replace all dates in a named range, use Find & Replace as described above. The Find & Replace feature searches the entire sheet regardless of whether cells are in a table or named range, so you do not need to select anything first.

Common mistakes when changing dates

The most common error is typing a date in an ambiguous format and having Excel guess wrong. For example, 03/04/2024 could mean March 4 or April 3 depending on your region. To avoid confusion, type the month as a word (March 4, 2024) or use the ISO format (2024-03-04), which Excel interprets the same way everywhere.

Another mistake is forgetting to press Enter after typing a new date. If you click away without pressing Enter, your change will not save. You will see the date you typed in the formula bar, but the cell will still show the old date. Always press Enter to confirm your edit.

A third issue is accidentally changing the format of a date when you meant to change only the value. If you right-click a date cell and select Format Cells, you are changing how the date looks, not what date it is. To change the actual date, click the cell and type a new date instead.

Frequently Asked Questions

Can I undo a date change if I made a mistake?

Yes. Press Ctrl+Z on Windows or Command+Z on Mac when ready after making the change. Excel will undo your last action. If you used Find & Replace and changed many dates at once, Ctrl+Z will undo all of them together. You can undo multiple steps by pressing Ctrl+Z several times.

What if I want to change only the year in a date, not the whole date?

Click the cell and type the complete new date. There is no way to edit just part of a date while leaving the rest alone. However, if you need to change the year in many dates, use a formula like =DATE(2025,MONTH(A1),DAY(A1)) to extract the month and day from the old date and combine them with a new year.

How do I change the date format without changing the actual date?

Right-click the cell containing the date, select Format Cells, click the Number tab, choose Date from the category list on the left, and pick a format from the options on the right. Click OK. The date value stays the same—only how it appears on screen changes.

Can I change dates in a locked or protected sheet?

No. If a sheet is protected, you cannot edit any cells unless the sheet owner has unlocked them specifically. Ask the sheet owner to unprotect the sheet or unlock the date cells you need to change. They can do this by going to the Review tab and clicking Unprotect Sheet.

What if Excel keeps changing my date to something else when I type it?

Excel may be auto-correcting based on your computer's regional settings. Type the date using the full month name (January 15, 2024) instead of numbers to avoid confusion. If that does not work, type an apostrophe before the date ('1/15/2024) to force Excel to treat it as text, then format the cell as a date afterward.