MIN Function for Dates in Excel: Find the Earliest Date

Formulas & functions · Updated November 20, 2026

To find the earliest date in an Excel range, use the MIN function: if your dates are in B2:B10, enter =MIN(B2:B10). Excel stores real dates as numbers, so MIN returns the smallest date value; format the result as a date if it appears as a number.

What MIN does with dates

MIN is Excel’s function for finding the lowest numeric value in a set of values. Although dates look different from ordinary numbers, Excel stores most dates as serial numbers: each day has a number, and later dates have larger numbers. The earliest date in a range is therefore its minimum value.

For example, suppose B2:B6 contains January 12, 2025; October 4, 2024; a blank cell; March 7, 2025; and November 19, 2024. With those dates in B2:B6, enter =MIN(B2:B6). The result is October 4, 2024. The formula does not need to be changed when dates are added elsewhere; it only considers the cells included in its range.

MIN does not look at how dates are displayed. A date shown as 10/4/2024 and the same date displayed as October 4, 2024 have the same underlying value. This is why the formula can find the right date even when the cells use different date formats.

Enter the formula and display its result

In Microsoft 365 for Windows, click the cell where you want the earliest date, type the formula, and press Enter. The formula can go in any empty cell outside the range being checked. If the result looks like a large number rather than a date, the calculation may already be correct: the result cell is probably formatted as General or Number.

  1. Select the cell containing the MIN formula.
  2. On the ribbon, choose Home > Number Format dropdown > Short Date, or select a date format from the dropdown.
  3. If you need a particular display style, press Ctrl+1 on Windows to open Format Cells and choose a date format. On Mac, use Command+1.

Formatting changes how the result is displayed, not the value MIN calculated. The formula is the same in Excel for Mac and Excel for the web, although ribbon placement and available date formats can vary slightly by platform.

How Excel stores dates—and why it matters

Excel dates are numbers with a date format applied. In the commonly used 1900 date system, dates progress by one serial number per day. A date entered as a valid Excel date is numeric underneath, so MIN can compare it with other dates. Times are stored as fractions of a day, which matters if the cells contain date-and-time values.

Excel workbooks can use either the 1900 or 1904 date system. The systems assign different serial numbers to the same calendar date, with a 1,462-day difference. Most users do not need to change this setting, but it can matter when copying raw date values between workbooks that use different systems. If dates shift unexpectedly after a workbook transfer, check the workbook’s date-system setting rather than assuming MIN is at fault.

Another important distinction is between a real date and text that merely looks like one. A cell containing a date stored as text is not necessarily treated as a date number by MIN. Date text can arise after importing data, pasting from another program, or using a format that Excel does not recognize for your region.

Blanks, text, zeros, and invalid dates

When MIN refers to a range, it ignores empty cells and text entries. That usually makes a simple range formula convenient: a blank cell among otherwise valid dates does not prevent Excel from finding the earliest date. However, MIN does include numeric zero. If a formula or imported data has placed zero in the date column, that value can become the minimum and may display as an unexpected early date or a zero-like date.

Check suspicious cells before changing the formula. Select one and look at the formula bar; also try changing its number format temporarily to General. A real date will show a serial number, while text may remain text. If dates were imported as text, convert them to actual dates using an appropriate import or conversion method. Excel’s Data > Text to Columns workflow can help with consistently structured text dates, but choose the date order carefully: a value such as 03/04/2025 is ambiguous between month/day and day/month formats.

  • Confirm that the source cells contain valid Excel dates, not text strings.
  • Look for zeros or formula results of zero in the date range.
  • Check that the range includes all intended rows and does not include a heading or unrelated numeric data.
  • Format the result cell as a date before concluding that a serial-number display is an error.

Find the earliest date that meets a condition

When you need the earliest date for a category, use MINIFS rather than MIN alone. MINIFS returns the smallest value from a range that meets one or more criteria. It is available in Microsoft 365 and modern Excel versions, including Excel 2019 and later.

Suppose column A contains regions and column B contains corresponding dates. With region names in A2:A10 and dates in B2:B10, enter =MINIFS(B2:B10,A2:A10,"North") to find the earliest date for North. If the North rows contain dates of February 8, April 12, and January 30, 2025, the result is January 30, 2025. Format the formula cell as a date if needed.

To exclude blank or zero entries in the date range, add a criterion requiring a positive date serial. With regions in A2:A10 and dates in B2:B10, enter =MINIFS(B2:B10,A2:A10,"North",B2:B10,">0"). This returns the earliest positive date for North, assuming valid dates are positive serial values. If no values match, MINIFS returns 0, so a result of zero may mean there is no qualifying date rather than that a real date was found.

Find the earliest date within a date range

You can use MINIFS to find the earliest date within a period, such as the first event in 2024. Use an inclusive start date and an exclusive start date for the following year. The exclusive upper limit is useful because it includes every date in December, even when the source values contain times.

With event dates in B2:B10, enter =MINIFS(B2:B10,B2:B10,">="&DATE(2024,1,1),B2:B10,"<"&DATE(2025,1,1)). This returns the earliest date at or after January 1, 2024, but before January 1, 2025. The DATE function constructs the boundary dates without relying on how a date string is interpreted by regional settings.

If the range might have no dates during the period, check for a match before interpreting the result. For instance, COUNTIFS can count dates meeting the same boundaries. MINIFS returning zero does not by itself distinguish “no qualifying date” from a meaningful result in a specially constructed dataset.

Dates with times and sorted lists

A date-and-time value includes both the day and a fractional part representing the time. MIN returns the earliest complete value, not merely the earliest calendar day. For example, 9:00 a.m. on June 5 is earlier than 3:00 p.m. on June 5. If the result cell is formatted to show only the date, the time may be hidden, making two distinct values look identical.

To inspect the time, apply a date-and-time number format to the result, or use Ctrl+1 on Windows (Command+1 on Mac) and select an appropriate format. If your question is only which calendar day is earliest, displaying just the date may be sufficient, but remember that MIN still compares the time portion.

You do not need to sort a date list before using MIN. Sorting oldest to newest can make the earliest date visible at the top, but it changes the order of the data and may affect related rows if the whole table is not sorted together. MIN is often safer when you only need the earliest value and want to leave the source order alone.

MIN versus MINIFS and other approaches

Use MIN when every valid date in the selected range is eligible. Use MINIFS when the earliest date must meet criteria, such as a particular department, customer, or year. If the records are already sorted oldest to newest, the first row may happen to contain the earliest date, but that is only reliable if the sort order is current and the list has no exceptions.

For a single condition, MINIFS is usually clearer than a complex array formula. It also allows multiple criteria, such as requiring a region and a status. If you are using an older Excel release without MINIFS, an array formula can be an alternative, but how it is entered depends on the Excel version. For a straightforward date list, using MIN is simpler and less error-prone.

MIN returns one value; it does not identify the row or the record associated with that date. If multiple records share the earliest date, MIN alone cannot tell you which one to retrieve. Use a lookup method when you need the matching person, description, or other fields, and decide how to handle duplicates.

Common troubleshooting checks

If the answer seems wrong, first check the source values and the exact range. A formula such as =MIN(B2:B10) will not include a new date entered in B11. Use a larger range or a structured table reference if the list grows regularly. Also make sure the formula cell is not included in its own range, which can create a circular reference.

If the answer is an unexpectedly old date, inspect for zero values and valid numeric entries that are not dates. MIN treats every number in the range as a candidate, including quantities or codes mistakenly mixed into the date column. If the answer is 0 for a conditional search, verify that the criteria text matches the source data and that qualifying dates are real numeric dates.

  • Use the formula bar to confirm the formula references the intended cells.
  • Check for hidden rows only if your expectation is based on visible records: MIN normally includes values in hidden rows.
  • Verify that the date column has no unrelated numbers or dates stored as text.
  • Check whether the result is merely displayed in General format rather than a date format.

Frequently Asked Questions

Does MIN work with dates in Excel?
Yes. Excel stores valid dates as numbers, and MIN returns the smallest date value in the range, which is the earliest date.

Why does MIN show a number instead of a date?
The result cell is probably formatted as General or Number. Apply a date format from Home > Number Format dropdown; the underlying result does not need to be recalculated.

Does MIN ignore blank date cells?
Yes, MIN ignores empty cells in a referenced range. It does not ignore numeric zero, so check for zeros if the result looks implausibly early.

How do I find the earliest date for one person or category?
Use MINIFS with the date range as its minimum range and the relevant category range as a criteria range. For example, it can return the earliest date for a named region.

Can MIN find the earliest date when cells include times?
Yes. It compares the full date-and-time values, so it returns the earliest instant. Format the result to show the time if you need to see that part of the value.

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.