Download Files:

Start File and Finished File:

[ Ссылка ]

See how to calculate Average Number of Days Between Dates in a Single Column:
1. Introduction
2. Helper Column and AVERAGE Function
3. AVERAGE Function Array Formula. Requires Ctrl + Shift + Enter
4. SUM & COUNT functions to make an aggregate formula.

Also see these related videos:
Excel Magic Trick 1388 Average Number of Days Between Order & Ship Date (Basic Array Formula Lesson)
Excel Magic Trick 1389: Average Number of Days Between Two Columns of Dates

свернуть