Excel Formulas to Find the Earliest & Latest Dates From the Given Range!!
Tags: excelformula, excelformulas
Published: 2021-05-17 04:21:52

---
title: Excel Formulas to Find the Earliest & Latest Dates From the Given Range!!
published: true
date: 2021-05-15 07:03:03 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-the-earliest-latest-dates-from-the-given-range/
---

Suppose you want to get the first and last date from the given input dates, how could you solve this problem quickly in Excel? Here, we will provide several tricks to **find out the earliest and latest dates from the given range in Excel**. Let’s get into the topic!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Get the earliest and latest date](https://geekexcel.com/wp-content/uploads/2021/05/Get-the-earliest-and-latest-date.png)](https://geekexcel.com/excel-formulas-to-find-the-earliest-latest-dates-from-the-given-range/get-the-earliest-and-latest-date/#main)<figcaption id="caption-attachment-42291">Get the earliest and latest dates</figcaption>

## Generic Formula:

- You can use the below formula to retrieve the earliest and latest dates associated with a project.

**Earliest Date =[MINIFS](https://geekexcel.com/how-to-use-excel-minifs-function-in-office-365-with-examples/)(data[Start],data[Project],F10)**

**Latest Date =[MAXIFS](https://geekexcel.com/how-to-use-excel-maxifs-function-in-office-365-with-examples/)(data[End],data[Project],F10)**

## Syntax Explanations:

- **MINIFS** – This function will help you to return the minimum value from the given input values specified by one or two conditions. Read more on the [**MINIFS function**](https://geekexcel.com/how-to-use-excel-minifs-function-in-office-365-with-examples/).
- **MAXIFS** – In Excel, the [**MAXIFS Function**](https://geekexcel.com/how-to-use-excel-maxifs-function-in-office-365-with-examples/) returns the largest numeric value from the range of input values based on the given condition or criteria.
- **Project** – This specifies the project name.
- **Start**  – It specifies the starting range from your worksheet.
- **End**  – It represents the ending range from your worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Let’s consider the below example image.

- Here, we will enter the input values in **Column B** , **Column C** , and **Column D**.
- To **convert the data into a table** , you have to select the input range and press the **CTRL** + **T** Keys.
- From this table, we need to find out the first and last dates based on the project names given in **Column F**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-29.png)<figcaption id="caption-attachment-42206">Input Ranges</figcaption>

- Select any cell and type the **Earliest D**** ate** formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-46.png)<figcaption id="caption-attachment-42208">Enter the formula</figcaption>

- It will display the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-44.png)<figcaption id="caption-attachment-42287">Result</figcaption>

- To get the last date, you have to use the **Latest Date** formula.

![Enter the 2nd formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-2nd-formula.png)<figcaption id="caption-attachment-42207">Enter the 2nd formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

![Result 1](https://geekexcel.com/wp-content/uploads/2021/05/Result-1-1.png)<figcaption id="caption-attachment-42289">Result 1</figcaption>

## Bottom-Line:

So yeah guys this is how we can **find out the earliest and latest dates in Excel based on certain conditions**. Hope you like it. Mention your **queries** in the **comment** box below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **