Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dates
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! |
#2
|
|||
|
|||
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. "James" wrote: 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! |
#3
|
|||
|
|||
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). |
#4
|
|||
|
|||
Thanks Dave and Dahlman.
James -----Original Message----- 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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting Dates | Excel Worksheet Functions | |||
Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |