Counting days between dates

  • Thread starter Thread starter aussiegirlone
  • Start date Start date
A

aussiegirlone

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
 
Just subtract:

A1 = 01-Jan-2008
B1 = 23-Jan-2008

=B1-A1

Format as General or Number
 
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?
 
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
 
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))
 
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
 
Back
Top