Get earliest and latest project dates

This example shows how to retrieve the earliest and latest dates associated with a project. In the example shown, the formulas in H5 and I5 are: =MINIFS(data[Start],data[Project],G5) // earliest =MAXIFS(data[End],data[Project],G5) // latest where "data" is an Excel table as shown, and project names in column G match those in column B. Note: MINIFS and MAXIFS are available only in Excel 365 and Excel 2019. In other versions of Excel, you can use a simple array formula, as explained below. Introduction The task here is to find the earliest and latest dates associated with a given project. The earliest dates come from the Start column, and latest dates come from the End column. You might be tempted to use a lookup function like VLOOKUP, XLOOKUP, or INDEX and MATCH. However, since each project has more than one entry, and entries may not always be sorted by date, this becomes challenging. A better approach is to use process of elimination: discard dates for other projects, and work only with the dates that are left.