Average DIFFERENCE between a list of numbers

[akedm]

Hello,

In my case, I want to know the average number of days between dates. Since dates are numbers, such as 44630, 44644, 44658, 44676, 44686, and 44708, what is the average number of days between them?

Average Difference.gif

Is there a formula that can extrapolate this? Or am I looking at a macro-only solution?

Thank you.

[oeldere]

=(B18-B13)/(COUNTA($B$13:$B$18)-1)


This gives the result 15.6


Alternative:

=(MAX($B$13:$B$19)-MIN($B$13:$B$19))/(COUNTA($B$13:$B$18)-1)

[Fluff13]

Another option which doesn't needs the dates sorted

Please Login or Register  to view this content.

[akedm]

Thank you both - I gotta learn LET.

Beautiful solutions, both of you, thank you - I just wasn't seeing it this morning.

[Fluff13]

Glad to help & thanks for the feedback