Excel Magic Trick 1390: Average Number of Days Between Dates in a Single Column 3 Examples

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

[initiald]

Every time i look at your video. Excel is more developed than i ever imagined. Thanks for sharing.

[alandouglas]

Absolutely fantastic video, I always love the logic you apply and the explanations that follow

[RobMichaels]

Could also use to avoid having to use CTRL+SHIFT-ENTER. Thanks for your videos I always look forward to the next installment !

[zaighamuddinfarooqui]

There is always something new to learn in your FUNtastic tutorials. :)

[OzduSoleilDATA]

AWWWW man! You've influenced me. I could see that array formula coming. :)

[staschistyakov]

I keep telling myself I will one day seriously sit down, look at some of your videos and try learn excel more indepth.

Today is not that day.

[Playstationshow]

Hey:

Could you please tell me how you displayed the formula for your average(s) two columns to the right? I.E. as soon as you pressed the enter key, a cell effortless transferred your formula input to text as "=Average(C11:C15)"?

Thank you;

[wilsonmeek]

Is there anyway to do this so it automated and I dont have to change the formula when I add new dates?

[ThePhoenixGC]

fucking legend this man is, thanks a ton!

[smithy]

Surely, just take the difference between the first and last dates in the list (16 days) and divide by the number of intervals (5)?

[jds]

looking for same solution but based on the contents of another column (groups), i know clear as mud... :/