Excel Max Date: What Is the Latest Date Excel Supports?

How-to basics · Updated November 18, 2026

Excel’s maximum supported date is December 31, 9999. In the standard 1900 date system used by Excel for Microsoft 365 on Windows, that date has the serial value 2958465; the 1904 date system uses a different serial for the same calendar date.

Excel’s maximum date at a glance

Excel represents dates as numbers, not as a special calendar data type. The number is a day count, and a date format tells Excel how to display it. In the default 1900 date system, Excel supports dates from January 1, 1900, through December 31, 9999. The last day is therefore the upper boundary for a normal Excel date.

To create that date in a worksheet, with the formula entered in any empty cell, use =DATE(9999,12,31). The result is December 31, 9999 when the cell is formatted as a date. The same cell contains the underlying serial number 2958465. If it displays as a number instead, apply a date format using Home > Number > Number Format dropdown > Short Date.

This limit applies to date values in current desktop Excel, including Microsoft 365 for Windows. Excel for Mac and Excel for the web also use the same general upper calendar-date limit. Workbook date-system settings can affect the serial number, but they do not move the final supported calendar date.

How Excel stores dates and serial numbers

A date-formatted cell contains a number. In the 1900 system, January 1, 1900, corresponds to serial 1, and later dates generally have larger serials. For example, adding one to a date’s serial advances it by one day. A time is stored as a fraction of a day: noon is one-half, while 6 a.m. is one-quarter. This is why Excel can store a date and time together in a single numeric value.

The 1900 system includes a historical exception: Excel treats 1900 as if it had a February 29, even though 1900 was not a leap year in the Gregorian calendar. This quirk was retained for compatibility with older spreadsheet software. In Excel’s serial sequence, serial 60 represents the fictitious date February 29, 1900; serial 61 represents March 1, 1900. The exception explains why serials around the start of the system do not match a straightforward Gregorian day count.

The quirk does not change the maximum date. December 31, 9999 still corresponds to serial 2958465 in the 1900 system. The serial number is useful when troubleshooting calculations or comparing values, but most users should enter or display dates in a recognizable date format rather than work with the serial directly.

The 1900 and 1904 date systems

Excel workbooks can use either the 1900 or 1904 date system. The 1900 system is the default for modern Excel workbooks on Windows. The 1904 system is found in some older workbooks and has historically been used on Mac. It starts its serial count at January 1, 1904, so the same calendar date has a different number in each system.

For December 31, 9999, the corresponding serial in the 1904 system is 2957003, which is 1,462 less than the 1900-system serial. Excel accounts for the workbook’s chosen system when displaying dates. The difference matters when numbers are copied between workbooks or interpreted by another program without the date-system setting.

On Windows, check the setting through File > Options > Advanced, then find the section labeled When calculating this workbook and inspect Use 1904 date system. On Mac, look under Excel > Preferences or Excel > Settings > Calculation; the menu wording can vary by release. Avoid changing the system in a workbook that already contains dates unless you have checked the effect: switching systems can shift how existing date serials display.

Finding the latest date with MAX

People asking about an Excel “max date” may mean the latest date in a list, rather than Excel’s absolute limit. The MAX function returns the largest numeric value in a range. Because dates are stored as numbers, it can identify the latest date when the cells contain genuine Excel date values.

With dates in A2:A5—January 10, 2024; July 4, 2024; March 15, 2026; and December 31, 2025—enter this formula in another cell: =MAX(A2:A5). The result is March 15, 2026, the latest date in the example. Format the result cell as a date if Excel shows a serial number instead.

MAX does not mean “the latest date Excel permits.” It simply returns the largest eligible number in the cells you specify. It also ignores text values in a referenced range, so a date that looks correct but was imported as text may not be considered. If the answer seems wrong, check that the source cells are real dates and that the range includes all the relevant rows. Sorting the list is not required for MAX to work.

Dates, times, and the upper boundary

Excel can include a time on December 31, 9999 because time is represented as a fraction of that day. For example, a date-time value late on that final day is still within the calendar limit. The date portion remains December 31, 9999; the fraction records the time. Applying a date-only format hides the time, while a date-and-time format can show both.

Adding a day to the final supported date would move the value into a date beyond Excel’s supported calendar range. Depending on the operation and cell format, an out-of-range result may produce an error or an unhelpful display; a large underlying number is not automatically a valid Excel date. Do not treat a string such as January 1, 10000, or an arbitrary larger serial, as a supported date just because it can be typed or stored as text or a number.

The same distinction matters for formulas. DATE can construct dates within Excel’s supported range, but it cannot make a valid date beyond the ceiling. If a calculation might cross the boundary—for example, adding a long duration to a date near the end of 9999—check the inputs and handle the out-of-range case rather than assuming the result remains a calendar date.

Common problems near Excel’s date limit

  • A cell shows ######: This usually means the column is too narrow for the formatted value, or that a date/time display cannot show the value as formatted. Widen the column first. The hash marks alone do not prove that the date is beyond Excel’s maximum.
  • A formula returns an unexpected result: Confirm that the input is a true date value, not text. Imported dates can look like dates while being stored as text, and MAX ignores text in a referenced range. Re-entering or converting the values using a method appropriate to their source can resolve the mismatch.
  • A copied date changes by years: The source and destination workbooks may use different date systems. Compare their 1900/1904 settings before relying on copied serial values.
  • A historical date will not behave like a modern date: The 1900 system does not provide ordinary Excel date handling for dates before January 1, 1900. A pre-1900 date may need to be kept as text or handled with a specialized approach, which can limit sorting and date arithmetic.
  • A date-looking value turns into a number: That is often the underlying serial being displayed with a General or Number format. Apply a date format; the number itself may be valid.

When the maximum date matters outside Excel

Excel’s ceiling can matter when a workbook exchanges dates with databases, software, or file formats. Systems do not all share the same date range, date origin, or treatment of times. A receiving application may reject a date Excel accepts, interpret a serial using the wrong starting system, or convert a date-time value with different precision. If a workbook feeds another process, confirm that process’s date limits and conversion rules instead of assuming that all applications interpret Excel serials alike.

For routine planning, reporting, and record keeping, the year 9999 is far beyond a practical business date. More commonly, a formula produces an implausibly distant date because a blank cell, text value, or incorrect unit was included in a calculation. Check the source data and formula logic before concluding that Excel has hit its maximum. If an external system requires a special placeholder for an unknown or open-ended date, use the convention agreed with that system; do not choose December 31, 9999 automatically, since another application may treat it differently.

Frequently Asked Questions

What is the maximum date in Excel?
December 31, 9999 is Excel’s maximum supported calendar date. In the 1900 date system, its serial number is 2958465.

What is the maximum Excel date serial number?
For December 31, 9999, the serial is 2958465 in the 1900 system and 2957003 in the 1904 system. Check the workbook’s date-system setting before comparing serials.

Can Excel display dates after December 31, 9999?
Not as supported Excel calendar dates. A number or text string beyond the limit is not the same as a valid date value, and date calculations beyond the boundary may error or display incorrectly.

Does MAX return the latest date in a list?
Yes, if the listed dates are real Excel date values. For dates in A2:A100, =MAX(A2:A100) returns the latest one; text-formatted dates may be ignored.

Why does Excel show a number instead of a date?
Excel stores the date as a serial number. Apply a date format to the cell to display it as a calendar date; the underlying value does not need to change.

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.