Get Earliest And Latest Project Dates Excel Formula
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....