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

  • Thread starter Thread starter Jenny G
  • Start date Start date
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.
 
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.
 
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 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
 
You must log in or register to reply here.

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
Summary of Difference between dates in years, months, days 3
Count numbers between 0 and 2 1
Dates in Excel 2007 5
How to calculate the number of days between two dates 2
subtracting date and time to find the difference between the two 4
Date Value Error 6
Trailing 30 days sum calculation with excel 1

Back
Top