Average formula for dates range - Excell 2007

[Radrays]

I am currently using a formula to calculate aging between dates. How can I
take that calculated column of information and find an average for aging?
Thank you in advance.
Radrays

 

[Mike H]

Hi,

The question is clear but if you have a column of ages and you want the
average age then

=average(a1:a100)

change range to suit

Mike

 

[Gary''s Student]

Here are dates in cols A & B and date aging in column C:

4/7/2009 3/24/2009 14
4/7/2009 4/6/2009 1
4/7/2009 3/19/2009 19
4/7/2009 3/25/2009 13
4/7/2009 4/3/2009 4
4/7/2009 4/2/2009 5
4/7/2009 3/27/2009 11
4/7/2009 3/31/2009 7
4/7/2009 3/24/2009 14
4/7/2009 4/6/2009 1

Then in another cell:

=AVERAGE(C1:C10) will display 9

 

[Radrays]

Below is the formula for the aging

=IF(DATEDIF(C3,D3,"y")=0,"",DATEDIF(C3,D3,"y")&"
year(s),")&IF(DATEDIF(C3,D3,"ym")=0,"",DATEDIF(C3,D3,"ym")&"
month(s),")&DATEDIF(C3,D3,"md")&" day(s)"

How can I convert in a seperate column to days only - then I could use that
column for the average...correct?

Thank you for your help,
Radrays

 

[Glenn]

With your dates in C320 use this array formula (commit with CTRL+SHIFT+ENTER)
for the average:

=SUM(C3:C20-D320)/SUM(--(C3:C20-D320<>0))