Days between 2 dates

  • Thread starter Thread starter Linda RQ
  • Start date Start date
L

Linda RQ

Hi Everyone,

Using Excel 2003. What function or formula would I use in Cell C1 to get
the count number of days between these two dates. If the time in Cell A1 is
PM, we don't want that day counted.

Cell A1
5/30/06@2:15am

Cell B1
6/19/06@6:16pm

Thanks,
Linda
 
Ooops I meant to say...
=INT(B1-A1)
but that's not really what you want is it? Try this one
=DATEDIF(A1,B1,"D")-(HOUR(A1)>11)
 
Why not just

=INT(B1-A1)-(HOUR(A1)>11)

but reading the OP, perrhaps it should be

=INT(B1-A1)+(HOUR(A1)<=11)



--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
It really depends on the OP's preference really. Look at the following
examples to see why I went with DATEDIF...

5/30/2006 2:15 AM
6/19/2006 1:15 AM
=INT(B1-A1) -> 19
=DATEDIF(A1,B1,"D") -> 20

5/30/2006 2:15 AM
6/19/2006 3:15 AM
=INT(B1-A1) -> 20
=DATEDIF(A1,B1,"D") -> 20
 
Back
Top