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