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

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

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

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.
--
John C


"Jenny G" wrote:

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

What is the formula for totalling the number of days between twod
 

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


On Aug 1, 5:37*pm, Jenny G <Jenny
wrote:
I need to find a formula that will calculate the number of days between two
dates in two different cells in Excel. *

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

On Fri, 1 Aug 2008 09:37:01 -0700, Jenny G <Jenny
wrote:

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


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