calculate average date

  • Thread starter Thread starter tracktraining
  • Start date Start date
T

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,
 
Nevermind. It does work. I just had to change the format of the cell. THANKS.
--
Learning


Bob Phillips said:
=AVERAGE(B1:B2-A1:A2)

which is an array formula, commit with Ctrl-Shift-Enter
Click to expand...
 
Back
Top