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" <(E-Mail Removed)> wrote in message
news:927B5877-1B36-448F-B806-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in
>> message
>> news:44388192-935C-4C6C-A71E-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in
>> >> message
>> >> news:46BEA5B8-8FD1-490E-98B8-(E-Mail Removed)...
>> >> > 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
>> >>
>> >>
>> >>
>>
>>
>>
|
Similar Threads
