Formula to calculate differences between dates??

G

Guest

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.
 
G

Guest

Simply subtract one date from the other to get the difference in days.
e.g. =(A1-B1) where A1 and B1 are dates

Excel will want to change the format of the cell that does this to a date
but change it back to general to get the difference in days.

To average delivery times is simply =average(c1:c10)

Mike
 
G

Guest

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
 
G

Guest

Thanks Mike...Is it possible to do this for a range of cells at once?? I
don't want to display the difference between the dates separately, just the
average at the end?
 
D

David Biddulph

Shipment date in A1
Received date in B1
Difference in days =B1-A1 (format as number or general)
 
A

AshParr

Format as a number

Ash

Shipment date in A1
Received date in B1
Difference in days =B1-A1 (format as number or general)
--
David Biddulph






- Show quoted text -
Click to expand...
 
D

David Biddulph

As a matter of interest, Ash, why do you object to formatting it as general?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding Date formula 1
Calculate Dates 2
Calculate business days between 2 dates 4
How to calculate the number of days between two dates 2
Power Pivot Variance Column 0
Calculation of time differences 4
Calculate Holding Period Returns Between Two Customizable Dates 1
Subtracting Dates 2

Top