The fastest way to enter a date in Excel

Type the date the way you normally write it — 1/15/2025 or January 15, 2025 or 15-Jan-2025 — and Excel recognizes it as a date. Press Enter, and the cell stores it as a date value, not text. This matters because date values let you sort, filter, and do math with those cells later.

Excel's default format depends on your computer's location settings. In the United States, 1/15/2025 works when ready. In other regions, you may need to use your local date format — for example, 15/1/2025 in the UK or 2025-01-15 in ISO format. If Excel treats your date as text instead, you typed it in a format your computer doesn't recognize.

If you want today's date without typing it, type =TODAY() in any cell and press Enter. If you want today's date plus the time, type =NOW(). Both update automatically each time you open the file.

Key Takeaways

  • Type dates in a format your computer recognizes — usually month/day/year in the US — and Excel stores them as date values you can sort and calculate with.
  • Use =TODAY() to insert today's date automatically, or =NOW() to add the current date and time.
  • Right-click a cell with a date, choose Format Cells, and pick a different date format from the list without changing the actual date value.
  • To calculate days between two dates, subtract one date from another — for example, =B2-A2 gives you the number of days between the dates in cells A2 and B2.
  • If a date shows as a number like 45000, the column is too narrow or formatted as a number instead of a date — widen the column or change the format.

Changing how a date looks without changing the date itself

Once you have entered a date, you can display it in dozens of different formats. Right-click the cell containing the date and select Format Cells. A dialog box opens. Click the Number tab if it is not already selected, then click Date in the Category list on the left.

The middle column shows all available date formats. Scroll through and click the one you want — for example, March 14, 2025 or 14-Mar-25 or 2025-03-14. The preview at the bottom shows how your date will look. Click OK when you have chosen. The date value itself does not change; only the way it displays on screen changes.

This is useful when you are sharing a spreadsheet with people in different countries or when you need dates to match a specific format for a report. The underlying date value stays the same, so sorting and calculations still work correctly.

Entering a range of dates quickly

If you need to fill a column with consecutive dates — for example, every day in January — type the first date in one cell and the second date in the cell below it. Then select both cells. Move your cursor to the small square in the bottom right corner of the selection (called the fill handle) until it turns into a plus sign, then drag down as far as you need. Excel continues the pattern automatically.

You can also select the first cell, then go to the Sheet menu, click Fill, and choose Series. A dialog opens where you can specify the starting date, the interval (daily, weekly, monthly, yearly), and how many dates you want. This method is faster when you need many dates or a specific interval like every other week.

Doing math with dates

Excel stores dates as numbers counting from January 1, 1900, so you can subtract one date from another to find the number of days between them. If cell A2 contains 1/1/2025 and cell B2 contains 1/15/2025, type =B2-A2 in a new cell and you get 14 — the number of days between those dates.

To add days to a date, use the same method in reverse. Type =A2+30 to get the date 30 days after the date in A2. To subtract days, type =A2-7 for the date 7 days before.

For more complex calculations — finding the number of months or years between two dates, or calculating someone's age — use the DATEDIF function. Type =DATEDIF(A2,B2,"D") for days, =DATEDIF(A2,B2,"M") for months, or =DATEDIF(A2,B2,"Y") for years. The function calculates the difference in the unit you specify.

Fixing dates that show as numbers or errors

Sometimes a date displays as a long number like 45321 instead of a readable date. This usually means the column is too narrow to display the full date. Double-click the border between the column letters at the top to auto-fit the column width, and the date should appear correctly.

If the date still shows as a number after widening the column, the cell is formatted as a number instead of a date. Right-click the cell, select Format Cells, click Date in the Category list, choose a format, and click OK. The number converts to a readable date.

If you see #VALUE! or #NAME? in a cell with a date formula, you likely typed the formula incorrectly or used a function name that Excel does not recognize. Check that you spelled the function name correctly and that all parentheses and commas are in the right places. Copy the formula from this article exactly if you are unsure.

Using dates in sorting and filtering

Once your dates are stored as date values — not text — you can sort a spreadsheet by date. Click any cell in the column with dates, then go to the Data menu and click Sort A to Z to sort from oldest to newest, or Sort Z to A to sort from newest to oldest.

You can also filter by date. Click the column header with dates, go to Data, and click AutoFilter. A small arrow appears in the column header. Click that arrow, and you can choose specific dates, date ranges, or conditions like "dates after January 1, 2025". This is useful when you have a long list and need to see only entries from a certain time period.

Common mistakes and how to avoid them

The most common mistake is typing a date in a format your computer does not recognize, which causes Excel to treat it as text instead of a date. Text dates cannot be sorted correctly or used in calculations. If you type 2025/01/15 on a computer set to US format, Excel may store it as text. Check your computer's regional settings or use the format your region expects.

Another mistake is forgetting to use the equals sign when entering a formula. Type =TODAY(), not TODAY(). Without the equals sign, Excel treats it as regular text and does not calculate anything.

A third mistake is mixing date formats in the same column. If some cells contain 1/15/2025 and others contain January 15, 2025, Excel may treat some as dates and others as text, breaking sorting and calculations. Pick one format and use it consistently, or format the entire column as dates after entering all the data.

Frequently Asked Questions

Can I enter just the month and year without a specific day?

Excel requires a complete date with a day, month, and year to store it as a date value. If you type 1/2025, Excel treats it as text. Instead, type 1/1/2025 to represent January 2025, then format the cell to display only the month and year. Right-click, choose Format Cells, click Date, and scroll to find a format like January 2025 or Jan-25.

How do I calculate someone's age from their birth date?

Use =DATEDIF(A2,TODAY(),"Y"), where A2 contains the birth date. This calculates the number of complete years between the birth date and today. The formula updates automatically each day, so the age increases on the person's birthday without you having to change anything.

What if my dates are in a different language or calendar system?

Excel recognizes dates based on your computer's regional settings. If your computer is set to a region that uses a different calendar — for example, the Islamic or Hebrew calendar — enter dates in the format your system expects. You can also change your computer's regional settings in your operating system, and Excel will follow that change.

Can I add a time to a date cell?

Yes. Type the date and time together, like 1/15/2025 2:30 PM or 1/15/2025 14:30. Excel stores both the date and time as a single value. Format the cell to show only the date, only the time, or both, depending on what you need.

Why does my date formula show the wrong result?

Check that both cells in your formula contain actual date values, not text that looks like a date. If one cell contains text, the calculation fails or gives an unexpected result. Right-click each cell, choose Format Cells, and confirm it is formatted as Date, not Text. If it is formatted as Text, change it to Date and re-enter the data.