| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting days between dates
What I am trying to do is calculate the days between accidents. My first
input date is 01-Jan- 2008 and my next input date is 23-Jan-2008. The days inbetween should count "22" if true, or if false then "False" PS: I do not want to count from the first inpute date to today, I only want to count from incident to incident. Can anyone help me please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between dates
Just subtract:
A1 = 01-Jan-2008 B1 = 23-Jan-2008 =B1-A1 Format as General or Number -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... What I am trying to do is calculate the days between accidents. My first input date is 01-Jan- 2008 and my next input date is 23-Jan-2008. The days inbetween should count "22" if true, or if false then "False" PS: I do not want to count from the first inpute date to today, I only want to count from incident to incident. Can anyone help me please |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between dates
Thankyou for your attempt but Please Note that I mentioned if true then "22"
if false then "false". in other words if no accident occured between or on either dates then the cell should say false but if an accident occured on the last input date it should return 22 Can you still help? "T. Valko" wrote: Just subtract: A1 = 01-Jan-2008 B1 = 23-Jan-2008 =B1-A1 Format as General or Number -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... What I am trying to do is calculate the days between accidents. My first input date is 01-Jan- 2008 and my next input date is 23-Jan-2008. The days inbetween should count "22" if true, or if false then "False" PS: I do not want to count from the first inpute date to today, I only want to count from incident to incident. Can anyone help me please |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between dates
You'll need to provide more detail.
How do you know if an accident occured? -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... Thankyou for your attempt but Please Note that I mentioned if true then "22" if false then "false". in other words if no accident occured between or on either dates then the cell should say false but if an accident occured on the last input date it should return 22 Can you still help? "T. Valko" wrote: Just subtract: A1 = 01-Jan-2008 B1 = 23-Jan-2008 =B1-A1 Format as General or Number -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... What I am trying to do is calculate the days between accidents. My first input date is 01-Jan- 2008 and my next input date is 23-Jan-2008. The days inbetween should count "22" if true, or if false then "False" PS: I do not want to count from the first inpute date to today, I only want to count from incident to incident. Can anyone help me please |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between dates
This is what my data page looks like however I want to be able to calculate
the days between the first accident and the last Accident in the column that says DAYS SINCE LAST ACCIDENT. If no accident has occured it remains false I hope this will help you to understand what I want done Date of Accident Time of Accident Number of Accidents Days Since last Accident 1/1/2008 12:30:00 PM 1 0 5/1/2008 FALSE FALSE 10/1/2008 FALSE FALSE 12/1/2008 FALSE FALSE 19/1/2008 FALSE FALSE 23/1/2008 5:30:00 PM 1 22 "T. Valko" wrote: You'll need to provide more detail. How do you know if an accident occured? -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... Thankyou for your attempt but Please Note that I mentioned if true then "22" if false then "false". in other words if no accident occured between or on either dates then the cell should say false but if an accident occured on the last input date it should return 22 Can you still help? "T. Valko" wrote: Just subtract: A1 = 01-Jan-2008 B1 = 23-Jan-2008 =B1-A1 Format as General or Number -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... What I am trying to do is calculate the days between accidents. My first input date is 01-Jan- 2008 and my next input date is 23-Jan-2008. The days inbetween should count "22" if true, or if false then "False" PS: I do not want to count from the first inpute date to today, I only want to count from incident to incident. Can anyone help me please |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between dates
Try this:
For the first entry in the "Days Since last Accident" column you'll have to manually enter a 0. Let's assume that is in cell D2. Then, enter this formula in cell D3 and copy down as needed: =IF(C3="",FALSE,A3-LOOKUP(1E100,C$2:C2,A$2:A2)) -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... This is what my data page looks like however I want to be able to calculate the days between the first accident and the last Accident in the column that says DAYS SINCE LAST ACCIDENT. If no accident has occured it remains false I hope this will help you to understand what I want done Date of Accident Time of Accident Number of Accidents Days Since last Accident 1/1/2008 12:30:00 PM 1 0 5/1/2008 FALSE FALSE 10/1/2008 FALSE FALSE 12/1/2008 FALSE FALSE 19/1/2008 FALSE FALSE 23/1/2008 5:30:00 PM 1 22 "T. Valko" wrote: You'll need to provide more detail. How do you know if an accident occured? -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... Thankyou for your attempt but Please Note that I mentioned if true then "22" if false then "false". in other words if no accident occured between or on either dates then the cell should say false but if an accident occured on the last input date it should return 22 Can you still help? "T. Valko" wrote: Just subtract: A1 = 01-Jan-2008 B1 = 23-Jan-2008 =B1-A1 Format as General or Number -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... What I am trying to do is calculate the days between accidents. My first input date is 01-Jan- 2008 and my next input date is 23-Jan-2008. The days inbetween should count "22" if true, or if false then "False" PS: I do not want to count from the first inpute date to today, I only want to count from incident to incident. Can anyone help me please |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between dates
This is what my data page looks like however I want to be able to calculate
the days between the first accident and the last Accident in the column that says DAYS SINCE LAST ACCIDENT. If no accident has occured it remains false I hope this will help you to understand what I want done Date of Accident Time of Accident Number of Accidents Days Since last Accident 1/1/2008 12:30:00 PM 1 0 5/1/2008 FALSE FALSE 10/1/2008 FALSE FALSE 12/1/2008 FALSE FALSE 19/1/2008 FALSE FALSE 23/1/2008 5:30:00 PM 1 22 "T. Valko" wrote: You'll need to provide more detail. How do you know if an accident occured? -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... Thankyou for your attempt but Please Note that I mentioned if true then "22" if false then "false". in other words if no accident occured between or on either dates then the cell should say false but if an accident occured on the last input date it should return 22 Can you still help? "T. Valko" wrote: Just subtract: A1 = 01-Jan-2008 B1 = 23-Jan-2008 =B1-A1 Format as General or Number -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... What I am trying to do is calculate the days between accidents. My first input date is 01-Jan- 2008 and my next input date is 23-Jan-2008. The days inbetween should count "22" if true, or if false then "False" PS: I do not want to count from the first inpute date to today, I only want to count from incident to incident. Can anyone help me please |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between dates
Thank you very much for your help the formular works beautiful
"T. Valko" wrote: Try this: For the first entry in the "Days Since last Accident" column you'll have to manually enter a 0. Let's assume that is in cell D2. Then, enter this formula in cell D3 and copy down as needed: =IF(C3="",FALSE,A3-LOOKUP(1E100,C$2:C2,A$2:A2)) -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... This is what my data page looks like however I want to be able to calculate the days between the first accident and the last Accident in the column that says DAYS SINCE LAST ACCIDENT. If no accident has occured it remains false I hope this will help you to understand what I want done Date of Accident Time of Accident Number of Accidents Days Since last Accident 1/1/2008 12:30:00 PM 1 0 5/1/2008 FALSE FALSE 10/1/2008 FALSE FALSE 12/1/2008 FALSE FALSE 19/1/2008 FALSE FALSE 23/1/2008 5:30:00 PM 1 22 "T. Valko" wrote: You'll need to provide more detail. How do you know if an accident occured? -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... Thankyou for your attempt but Please Note that I mentioned if true then "22" if false then "false". in other words if no accident occured between or on either dates then the cell should say false but if an accident occured on the last input date it should return 22 Can you still help? "T. Valko" wrote: Just subtract: A1 = 01-Jan-2008 B1 = 23-Jan-2008 =B1-A1 Format as General or Number -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... What I am trying to do is calculate the days between accidents. My first input date is 01-Jan- 2008 and my next input date is 23-Jan-2008. The days inbetween should count "22" if true, or if false then "False" PS: I do not want to count from the first inpute date to today, I only want to count from incident to incident. Can anyone help me please |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between dates
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... Thank you very much for your help the formular works beautiful "T. Valko" wrote: Try this: For the first entry in the "Days Since last Accident" column you'll have to manually enter a 0. Let's assume that is in cell D2. Then, enter this formula in cell D3 and copy down as needed: =IF(C3="",FALSE,A3-LOOKUP(1E100,C$2:C2,A$2:A2)) -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... This is what my data page looks like however I want to be able to calculate the days between the first accident and the last Accident in the column that says DAYS SINCE LAST ACCIDENT. If no accident has occured it remains false I hope this will help you to understand what I want done Date of Accident Time of Accident Number of Accidents Days Since last Accident 1/1/2008 12:30:00 PM 1 0 5/1/2008 FALSE FALSE 10/1/2008 FALSE FALSE 12/1/2008 FALSE FALSE 19/1/2008 FALSE FALSE 23/1/2008 5:30:00 PM 1 22 "T. Valko" wrote: You'll need to provide more detail. How do you know if an accident occured? -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... Thankyou for your attempt but Please Note that I mentioned if true then "22" if false then "false". in other words if no accident occured between or on either dates then the cell should say false but if an accident occured on the last input date it should return 22 Can you still help? "T. Valko" wrote: Just subtract: A1 = 01-Jan-2008 B1 = 23-Jan-2008 =B1-A1 Format as General or Number -- Biff Microsoft Excel MVP "aussiegirlone" wrote in message ... What I am trying to do is calculate the days between accidents. My first input date is 01-Jan- 2008 and my next input date is 23-Jan-2008. The days inbetween should count "22" if true, or if false then "False" PS: I do not want to count from the first inpute date to today, I only want to count from incident to incident. Can anyone help me please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting days between 2 dates | Excel Discussion (Misc queries) | |||
| Counting Days Between Dates | Excel Worksheet Functions | |||
| Counting no of days from a list of running dates for a 12 month pe | Excel Discussion (Misc queries) | |||
| challenging formula(for me), counting days between dates for multipleyears | Excel Worksheet Functions | |||
| Counting days between dates | Excel Discussion (Misc queries) | |||
Linear Mode
