Average number of days between dates

[vulpes_vulpes_3]

Hi all,

I'm new to this forum. I'm stuck with something. I need to estimate delivery cycles.


I have dates on column B

[TABLE="width: 150"]
<tbody>[TR]
[TD][/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Delivery[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]January 10[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]February 11[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]March 15[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]April 22[/TD]
[/TR]
</tbody>[/TABLE]

I need to get average days between the delivery dates

I could do it like this:

=AVERAGE(DAYS(B3;B2); DAYS(B4;B3); DAYS(B5;B4))

However it won't work if I want to add new dates.

Is there any easier way to get the average delivery cycle?
I believe that the answer is simple but I just can't get that right now....



Thank you!

 

[Nine Zero]

Add a helper column in column C and add this formula in cell B3 and drag down as far as you think you will be entering data

=IF(NOT(ISBLANK(B3)),B3-B2,"")

then in cell D2 ....or whereever you want your average to appear.... simply do

=AVERAGE(C:C)