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