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

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

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

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

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

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

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

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

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