Download Files:

Start File and Finished File:

[ Ссылка ]

See how to calculate the Average Number of Days Between Order Date & Ship Date with three different methods:

1. (00:10) Introduction
2. (00:25) Helper Column Method & AVERAGE Function
3. (02:22) Array Formula #1: AVERAGE Function with Array Operation. This Requires the special keystrokes: Ctrl + Shift + Enter
4. (03:12) Learn how to Name Ranges (Defined Names) with Create Names From Selection feature
5. (08:36) Array Formula #2: SUMPRODUCT, Array Operation & COUNT function
6. (11:42) Summary

Reference Videos:
Excel Magic Trick 1389: Average Number of Days Between Two Columns of Dates
Excel Magic Trick 1390: Average Number of Days Between a Single Columns of Dates

свернуть