View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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