What is the formula for totalling the number of days between two d

J

Jenny G

I need to find a formula that will calculate the number of days between two
dates in two different cells in Excel.
 
J

John C

C1: =B1-A1
Where C1 is where you wan the difference to show, A1 is the earlier date,
and B1 is the later date. If you don't know necessarily which one will be
later, you could do the following:
C1: =ABS(A1-B1)

Ensure, in either case, cell C1 is formatted as General or a number.
 
P

Pete_UK

Just subtract them. You might need to add 1, depending on whether you
want the number of elapsed days or not.

Hope this helps.

Pete
 
L

Lars-Åke Aspelin

On Fri, 1 Aug 2008 09:37:01 -0700, Jenny G <Jenny
I need to find a formula that will calculate the number of days between two
dates in two different cells in Excel.
Click to expand...


If the two dates are in cells A1 and B1 then put the following formula
in cell C1:

=B1-A1

Format cell C1 as number.

Hope this helps / Lars-Åke
 
Top