Thank you Teethless! However, I don't think this is working for me. I will
give you exact specifics:
Column L = order date
Column M = shipped date (formatted as 23-Mar-07)
Cell ranges are from L8-L211 & M8-M211
I would like the formula to calculate the days between the 2 dates & average

"Teethless mama" wrote:

=AVERAGE(B1:B3-A1:A3)

ctrl+shift+enter, not just enter


"Lisa" wrote:

MORE SPECIFICALLY....
All in one formula, I would like to calucate the average of the differences
between the dates between A & B (where B is a later date), for 200 rows.
Date cells are formatted as dates. I don't need a column that displays the
difference between each date, just the average at the end.

A B
1 02-Mar-07 04-Mar-07
2 04-Mar-07 09-Mar-07
3 08-Mar-07 13-Mar-07
4 27-Mar-07 29-Mar-07

"Lisa" wrote:

Is there a formula to calculate the days between two different dates?? For
example, I have a spreadsheet which contains the shipment date and the date
something was received - I would like to have a formula to automatically
calculate the difference between these two, but to also average the
difference.
Thanks in advance.