calculate average date

[tracktraining]

Hi All,

I calculated the number of days between two dates with
=DATEDIF(A1,B1,"d")&" days ".

Column 1 Column 2 =DATEDIF(column1,column2,"d")&" days "
2/4/2008 6/4/2008 121 days
4/1/2001 6/20/2008 2637 days

I would like to know how to calculate the average days. how can this be
done? I used the average function and it didn't work. Please help if
possible.

Thanks,

 

[Bob Phillips]

=AVERAGE(B1:B2-A1:A2)

which is an array formula, commit with Ctrl-Shift-Enter

 

[tracktraining]

that doesn't work. I got #Value! error.

--
Learning

=AVERAGE(B1:B2-A1:A2)

which is an array formula, commit with Ctrl-Shift-Enter

 

[tracktraining]

Nevermind. It does work. I just had to change the format of the cell. THANKS.
--
Learning

=AVERAGE(B1:B2-A1:A2)

which is an array formula, commit with Ctrl-Shift-Enter

 

[David Biddulph]

Why DATEDIF and not just B1-A1 ?