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

=SUM(C3:C20-D3:D20)/SUM(--(C3:C20-D3:D20<0))

Radrays wrote:
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

"Mike H" wrote:

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

"Radrays" wrote:

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