Excel Min Date: Earliest Date and MIN Formula

Formulas & functions · Updated November 18, 2026

In Excel for Microsoft 365 on Windows, the earliest date Excel can store as a date in its standard 1900 date system is January 1, 1900. To find the earliest date in a range, put the dates in A2:A100 and enter =MIN(A2:A100) in another cell; format the result as a date if Excel displays a number.

What “Excel min date” can mean

The phrase “Excel min date” often refers to one of two things: the earliest date the program can represent, or the formula for finding the earliest date in a set of records. They are related, but the answer is not the same. Excel’s date system has a starting point, while the MIN function returns the smallest numeric value in the cells you specify.

For ordinary workbooks using the 1900 date system, January 1, 1900 is serial date 1. Excel stores dates as numbers so it can sort them and calculate elapsed time. The number 1 represents January 1, 1900; later dates have larger serial numbers. That is why MIN can find the earliest date by selecting the smallest value.

There are limits and exceptions. A date earlier than the system’s starting point generally cannot be stored as a normal Excel date in that date system. It may be kept as text, but then Excel will not treat it as a date for ordinary date arithmetic or as a numeric date in MIN.

How Excel stores dates

An Excel date is a serial number with a date format applied. In the 1900 date system, serial 1 represents January 1, 1900, and the serial numbers increase by one for each calendar day. A date such as January 1, 2025, is stored as a much larger number. The exact number is usually hidden by a display format such as Short Date.

Time is stored as a decimal fraction of a day. For example, a value can represent a date plus a time such as 6:00 a.m. When MIN compares date-and-time values, it compares the full serial numbers, not just the calendar dates. Thus, 9:00 a.m. on a given day is later than midnight on that same day, even though both display the same date if the cells use a date-only format.

This storage method explains why a formula may show a number instead of a date. The calculation can be correct; the result cell simply has a General or Number format. Select the result, then choose Home > Number Format dropdown > Short Date. To see the underlying serial value, temporarily change the format to General.

Find the earliest date with MIN

For dates in A2:A100, enter this formula in an empty cell:

With dates in A2:A100, use =MIN(A2:A100). If the earliest entry is March 4, 2022, the formula returns that date’s serial number, which displays as March 4, 2022, when the result cell has a date format.

MIN is useful for a straightforward list because it needs no special date-specific function. It also works across more than one range, provided the ranges contain comparable numeric values. For a clear result, keep the input range limited to the date column rather than including unrelated quantities such as invoice totals or row numbers.

  • Enter the formula outside the source range so it does not create a circular reference.
  • Format the result as a date using Home > Number Format dropdown > Short Date.
  • Check whether the source cells contain real dates rather than text that only looks like dates.
  • If the answer seems unexpectedly early, look for a zero or another numeric value in the selected range.

Find the earliest date that meets a condition

To find the first date for a particular category, use MINIFS in Microsoft 365 or Excel 2019 and later. For example, suppose dates are in B2:B100 and statuses are in A2:A100. With those ranges, use =MINIFS(B2:B100,A2:A100,"Open") to return the earliest date whose corresponding status is Open. Format the result as a date.

The dates and criteria range must have matching dimensions: each date in B2:B100 is paired with a status in the same row of A2:A100. You can use a cell reference for the condition instead of typing Open into the formula. For instance, if the requested status is in D1, use =MINIFS(B2:B100,A2:A100,D1), with the same data layout and the condition in D1.

MINIFS returns 0 if no rows meet the condition. Since zero is not a normal date in the 1900 system, the result may appear as a zero, a date-like value, or another display depending on formatting. Check that the condition exists and that the matching date cells contain numeric dates before interpreting that result as a real earliest date.

1900 and 1904 date systems

Excel workbooks can use either the 1900 or 1904 date system. The 1900 system is the standard for Excel for Windows. The 1904 system begins on January 1, 1904, so the same calendar date has a different serial number in the two systems. For dates common to both systems, their serial values differ by 1,462 days.

That difference matters when copying dates between workbooks that use different systems. Excel may adjust dates when transferring data, but linked workbooks or other data-handling situations can produce apparent shifts. If dates suddenly move by about four years after a workbook is copied or linked, check the date-system setting before changing the data manually.

In Windows Excel, the setting is at File > Options > Advanced > When calculating this workbook > Use 1904 date system. On a Mac, the setting is in Excel > Settings (called Preferences in some releases) > Calculation; its exact presentation can vary by version. Check the setting in the workbook that contains the dates. Changing it affects date interpretation across that workbook, so do not toggle it casually in a file with established calculations.

The 1900 leap-year anomaly

Excel preserves a historical compatibility behavior in its 1900 date system: it treats 1900 as if it had a February 29. In reality, 1900 was not a leap year under the Gregorian calendar. This behavior was retained so Excel would align with older spreadsheet software, and it affects serial numbers around the beginning of March 1900.

For everyday modern dates, this anomaly rarely matters. It can matter in historical datasets, calculations spanning early 1900, or comparisons with software that uses a different date convention. Do not assume that every serial number near the start of Excel’s calendar maps perfectly to a real Gregorian date. If a project needs historically exact dates before March 1900, verify how the receiving program handles them and consider storing the source dates as text with an explicit interpretation.

Common reasons MIN returns the wrong-looking answer

A result that seems wrong is often caused by the data or range rather than by MIN itself. MIN evaluates numeric values. A true Excel date is numeric, but text such as an imported value that looks like “04/03/2023” may not be. Its interpretation can also depend on regional date settings: that string could be read as April 3 or March 4.

  • Text dates: Convert imported text to real dates before relying on MIN. Depending on the source, Data > Text to Columns or a carefully checked conversion may help. Confirm the result by changing a cell to General and checking that it displays a number.
  • Zeros: A numeric zero is smaller than every ordinary modern date serial, so MIN may return zero. Find and correct zero placeholders or exclude them with an appropriate method.
  • Blanks: Empty cells in a referenced range are ignored by MIN. A cell containing a formula that returns an empty string is not a normal numeric date either.
  • Unexpected cells: A stray number, such as an ID or a value copied into the date column, can become the minimum. Review the range and inspect unusually small values.
  • Errors: An error value in the selected range can make the result an error. Resolve or handle the source error before relying on the minimum.
  • Time values: A date with a time can affect which entry is earliest within a day. Apply a date-and-time format temporarily if same-day times could explain the result.

Dates before 1900 and alternatives

Excel’s normal 1900 date system cannot represent dates before its starting point as ordinary date serials. Typing a pre-1900 date may leave it as text or fail to produce a usable date, depending on how it is entered. In that case, MIN cannot reliably compare it as a date with numeric Excel dates.

If a dataset genuinely includes older dates, choose a consistent representation for the whole dataset. One option is ISO-style text such as 1752-09-14, which sorts chronologically as text when every value uses the same year-month-day layout and fixed-width components. However, text dates do not behave like Excel dates in date arithmetic. For historical analysis that needs calculations, consider a documented conversion scheme or a specialist data system, and verify calendar conventions such as the transition between Julian and Gregorian dates.

For data after 1900, storing genuine Excel dates is usually the practical choice. Avoid mixing text dates, numeric dates, and serial numbers in one column. If the data comes from an external system, check its date format and regional conventions during import rather than assuming Excel interpreted every value correctly.

Frequently Asked Questions

What is the minimum date in Excel?
In the standard 1900 date system, January 1, 1900, is the first ordinary Excel date and has serial number 1. Workbooks using the 1904 date system begin at January 1, 1904.

What formula finds the earliest date in Excel?
Use MIN on the cells that contain dates. With dates in A2:A100, enter =MIN(A2:A100), then format the result as a date if it appears as a number.

Why does MIN show 0 instead of a date?
A zero in the selected range may be the smallest numeric value, or a conditional minimum may have found no matching rows. Check for zero placeholders and confirm that the relevant cells contain real dates.

Can Excel calculate dates before 1900?
Not as ordinary date serials in the 1900 date system. Such values may be stored as text, but text does not support normal date arithmetic or behave like a numeric date in MIN.

Why did a date change when I moved it to another workbook?
The workbooks may use different date systems. The 1900 and 1904 systems assign different serial numbers to the same calendar day, with a 1,462-day difference for dates shared by both systems. Check each workbook’s date-system setting.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.