Finding The Average of a Column of Dates to Today's Date

[sungersoo]

I have a column with a wide range of dates which I would like the average of all of those dates to Today's Date.

Is that possible?

Thank you in advance!

i.e.
Column A
10/21/2017
10/20/2017
8/1/2017

The average would be approx. 47 days

 

[barry houdini]

You can subtract the average of the dates from today's date, i.e.

=TODAY()-AVERAGE(A2:A10)

format result as number

 

[sungersoo]

You can subtract the average of the dates from today's date, i.e.

=TODAY()-AVERAGE(A2:A10)

format result as number

Wow. Too simple... Thank you!

 

[Logit]

.
Another method (more involved ) :

Excel 2007 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

1​

[/td][td]

10/21/2017​

[/td][td]

11/10/2017​

[/td][td]

20​

[/td][td][/td][td]

47​

[/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

2​

[/td][td]

10/20/2017​

[/td][td]

11/10/2017​

[/td][td]

21​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

3​

[/td][td]

8/1/2017​

[/td][td]

11/10/2017​

[/td][td]

101​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td][/td][td][/td][td]Formula in C1, drag down : =B1-A1[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td][/td][td][/td][td]Formula in E1, =AVERAGE(C:C)[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

9​

[/td][td][/td][td][/td][td]Format E1 as NUMBER, no decimals.[/td][td][/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]