Dates

  • Thread starter Thread starter James
  • Start date Start date
J

James

I have two cells with a data in each cell. Is there a
formula that I could put in a third cell that determines
the number of days between the two dates?

i.e.

A1 = 4 March 2004
A2 = 28 December 2004
A3 = formula that subtracts A2 from A1 to get the number
of days between these two dates.

Many thanks!
 
Treat your dates as though they are numbers. That is what excel does. So all
you have to do is in column 3 enter =B1-C1. You may have to change the format
of the cell by right clicking on it, choosing format, and underneath "Number"
click on number.
 
Your formula is:
=A2-A1

If you try it the other way around, you'll get a negative number. Just
remember to format the cell with the formula as a number (as opposed to
a date).
 

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

Subtracting Dates 4
Populate row with work days 1
Continuous Invoice Nos. 3
Count until condition is met and then retain final count 2
Combining Text From Cells 3
subtracting date and time to find the difference between the two 4
Formula for finding Date difference between 2 dates 4
Difference between two times in seconds 1

Back
Top