Format as a number

Ash

On 30 Mar, 14:50, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Shipment date in A1
Received date in B1
Difference in days =B1-A1 (format as number or general)
--
David Biddulph

"Lisa" wrote in message

...



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.- Hide quoted text -

- Show quoted text -