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
|
|||
|
|||
IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES
Does anyone know of a formula that will calculate how many days are from one
date to another? For example from March 30 to April 8. This is for the purpose of getting the average amount of days for processing. Your help is highly appreciated. I am using Exel 2003. |
#2
|
|||
|
|||
IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES
In Excel, dates are numbers, 1 per day, starting at 1-1-1900 (roughly).
So if the start date is in A1 and the end date is in A2, this gives you the number of days between them: =A2-A1 Important! Format as Number, not as Date (which is what Excel does automatically, trying yo be helpful, in vain) -- Kind regards, Niek Otten Microsoft MVP - Excel "Alohalady" wrote in message ... Does anyone know of a formula that will calculate how many days are from one date to another? For example from March 30 to April 8. This is for the purpose of getting the average amount of days for processing. Your help is highly appreciated. I am using Exel 2003. |
#3
|
|||
|
|||
IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES
On Sat, 5 Jun 2010 13:19:15 -0700, Alohalady wrote:
Does anyone know of a formula that will calculate how many days are from one date to another? For example from March 30 to April 8. This is for the purpose of getting the average amount of days for processing. Your help is highly appreciated. I am using Exel 2003. A date is a whole number. If you have one date in A1 and the other in B1 then the number of days is =A1-B1 or =B1-A1 Depending on what else is going on, you might have to change the formatting of that cell to Number. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com Shikata ga nai... |
Thread Tools | |
Display Modes | |
|
|