DATEDIF & Dynamic Arrays | Calculating the months to complete a project | Don’t Rush Edition

How do you calculate the number of months to complete a project? Here are problems:
Problem 1:

This project had 5 steps and each started and finished on different days …
Step1 12JAN – 19FEB
Step2 15JAN – 19JAN
Step3 30JAN – 27AUG
Step4 5JUL – 15JUL
Step5 1AUG – 11AUG

Problem 2:
A stack of multiple projects with multiple steps.

Solution involves:
Dynamic Arrays
DATEDIF
UNIQUE
MINIFS & MAXIFS

#DynamicArrays
#DATEDIF
#UNIQUE

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2