If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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! . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I can't remove the dates from Visio | Tom Rippert | Visio | 0 | March 25th, 2005 06:02 PM |
Crosstab query with irregularly-spaced dates | Carl Rapson | Running & Setting Up Queries | 2 | March 17th, 2005 10:42 PM |
Change Start Dates without Changing Due Dates | Beth | General Discussion | 0 | August 19th, 2004 03:44 PM |
Charting woes with hidden dates | dustin pockets | Charts and Charting | 4 | April 15th, 2004 04:20 AM |
subtracting dates to give a whole number | Lasitter | Worksheet Functions | 2 | October 1st, 2003 09:14 AM |