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 your spreadsheet uses, and press Enter. Excel recognizes most common date formats — including 1/15/2024, January 15, 2024, and 15-Jan-24 — so you can type whichever feels natural. The cell will automatically reformat to match the rest of your spreadsheet.

If you need to change many dates at once, or if Excel is not recognizing your date as a date, the method depends on what went wrong. A date that looks like text (left-aligned instead of right-aligned) needs a different fix than a date that is formatted as a number. This guide covers both situations and shows you how to avoid the most common mistakes.

Key Takeaways

  • Click the cell, type the new date, and press Enter — Excel will reformat it to match your spreadsheet's style automatically.
  • If a date appears left-aligned or will not calculate correctly, it is stored as text and needs to be converted to a real date first.
  • Use Find & Replace to change the same date across many cells at once without editing each one individually.
  • Change how dates display without changing the actual date by right-clicking the cell, selecting Format Cells, and choosing a different date format from the list.
  • Dates imported from other programs often arrive as text or numbers; converting them takes one extra step but prevents calculation errors later.

Editing a single date the straightforward way

Click the cell that contains the date you want to change. You can either double-click to edit inside the cell, or click once and start typing — either method works. Type the new date using any standard format: 3/22/2024, March 22 2024, 22-Mar-24, or 2024-03-22 all work equally well.

Press Enter when you are finished. Excel will convert your entry to the date format already used in that column. If the column shows dates as "3/22/2024", your entry will appear that way. If the column shows "22-Mar-24", Excel reformats your entry to match. This automatic matching keeps your spreadsheet consistent without extra steps.

If Excel does not recognize what you typed as a date — for example, if you type "March 32" or a date that does not exist — it will either reject the entry or store it as text. Type the date in a format Excel understands: month/day/year, day-month-year, or the full month name followed by the day and year.

Changing dates that are stored as text

A date stored as text looks like a date but behaves like words. It sits on the left side of the cell instead of the right, and if you try to use it in a formula — for example, to calculate days between two dates — Excel will not recognize it. You can spot text dates by their left alignment or by trying to sort them: text dates sort alphabetically instead of chronologically, so "2/1/2024" appears before "1/15/2024".

To convert a text date to a real date, use the DATEVALUE function. Click an empty cell and type =DATEVALUE(A1), replacing A1 with the cell containing your text date. Press Enter. The result is a real date that Excel recognizes. Copy this cell, then click the original cell with the text date, right-click, and select Paste Special. Click the Values radio button and press Enter. This replaces the text with the converted date.

If you have many text dates to convert, this method is faster than editing each one. After you convert them all, delete the helper column you created with the DATEVALUE formulas. Your dates will now sort correctly and work in calculations.

Using Find & Replace to change dates across many cells

If the same date appears in multiple cells and you need to change all of them at once, use Find & Replace instead of editing each cell individually. Press Ctrl+H (or Cmd+H on Mac) to open the Find & Replace dialog. Type the date you want to find in the Find field — for example, "1/15/2024" — and type the new date in the Replace field.

Click Replace All to change every instance at once. Excel will tell you how many cells it changed. This method works only if the date appears exactly as you type it, so if your spreadsheet shows "January 15, 2024" but you search for "1/15/2024", the search will find nothing. Type the date in the exact format your spreadsheet displays.

If you want to be cautious, click Replace once to see the first match, verify it is the right cell, and then click Replace All. This prevents accidentally changing dates in cells you did not intend to modify.

Changing how dates display without changing the actual date

Sometimes you do not want to change the date itself — you want to change how it appears. For example, you might want to show "March 15, 2024" instead of "3/15/2024", or show the day of the week along with the date. Right-click the cell or cells containing the dates and select Format Cells.

Click the Number tab (it is usually already selected). In the Category list on the left, click Date. A list of date formats appears on the right. Click the format you want — for example, "March 15, 2024" or "Friday, March 15, 2024" — and click OK. The dates in your cells will display in the new format, but the actual date stored in Excel does not change. Formulas that use these cells will still work correctly.

If none of the built-in formats match what you want, you can create a custom format. At the bottom of the Format Cells dialog, you will see a Type field. You can type a custom format code here — for example, dddd, mmmm d, yyyy produces "Friday, March 15, 2024". This is advanced, but it gives you complete control over how dates appear.

Fixing dates that arrived as numbers from another program

When you import data from another program — such as a database or accounting software — dates sometimes arrive as numbers like 45375 instead of recognizable dates. These are serial numbers: Excel stores every date as a number counting days since January 1, 1900. The number 45375 represents a real date, but you need to tell Excel to display it as a date instead of a number.

Click the cell or cells containing these numbers. Right-click and select Format Cells. Click the Number tab, select Date from the Category list, choose the format you want, and click OK. The numbers will when ready convert to readable dates. The actual data does not change — only how Excel displays it.

If the dates still look wrong after formatting — for example, if they are off by several years — the source program may have used a different starting date for its serial numbers. In that case, you may need to add or subtract a number of days. Check the source program's documentation or contact the person who exported the data to confirm the correct date.

Common mistakes to avoid when changing dates

The most frequent error is typing a date that Excel does not recognize as a date. If you type "13/25/2024" (an impossible date) or "2024/March/15" (an unusual order), Excel may store it as text instead of converting it to a date. Stick to formats Excel expects: month/day/year, day/month/year with a slash or dash, or the full month name followed by day and year.

Another common mistake is changing a date in a cell that other cells reference with formulas. If cell B1 contains a formula like =A1+7 (which adds 7 days to the date in A1), changing the date in A1 will automatically update B1. This is usually what you want, but if you have many formulas depending on a date, double-check that changing it will not break calculations elsewhere in your spreadsheet.

A third mistake is assuming that a date that looks correct is actually a date. Always verify by checking the cell's alignment (dates are right-aligned, text is left-aligned) or by trying to use it in a formula. If the formula does not work, the cell probably contains text, not a date, and you will need to convert it first.

Frequently Asked Questions

Can I change multiple dates at once without using Find & Replace?

Yes, if all the dates need to change by the same amount. Select all the cells containing dates, right-click, and select Format Cells. Click the Number tab and choose a different date format. This changes how they display but not the actual dates. To shift all dates forward or backward by a number of days, use a formula in a helper column, then copy and paste the results back as values.

What if Excel keeps treating my date as text no matter what I type?

The cell itself may be formatted as text. Right-click the cell, select Format Cells, click the Number tab, and change the category from Text to General or Date. Then click the cell again and re-enter the date. Excel should now recognize it as a date instead of text.

How do I change the date format for an entire column at once?

Click the column header to select the whole column. Right-click and select Format Cells. Click the Number tab, select Date from the Category list, choose your preferred format, and click OK. Every date in that column will display in the new format. This does not change the actual dates, only how they appear.

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

Yes. Press Ctrl+Z (or Cmd+Z on Mac) when ready after making the change. Excel will revert to the previous date. If you used Find & Replace and changed many dates at once, Ctrl+Z will undo all of them together. If you have already saved the file, undo may not be available.

Why does my date show as a number like 45375 after I paste it?

The cell is formatted as a number instead of a date. Right-click the cell, select Format Cells, click the Number tab, select Date from the Category list, and click OK. The number will display as a date. If it still shows incorrectly, the source data may use a different date system — check where the data came from.