Days between 2 dates
 

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

Days between 2 dates
 

=INT(B1-C1)

you will have to format the cell as a number after putting in the formula.

"Linda RQ" wrote:

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

Days between 2 dates
 

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)


"Sloth" wrote:

=INT(B1-C1)

you will have to format the cell as a number after putting in the formula.

"Linda RQ" wrote:

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

Days between 2 dates
 

One way:

=INT(B1-ROUND(A1,0))



=BIn article ,
"Linda RQ" wrote:

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

Days between 2 dates
 

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)

"Sloth" wrote in message
...
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)


"Sloth" wrote:

=INT(B1-C1)

you will have to format the cell as a number after putting in the
formula.

"Linda RQ" wrote:

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

Days between 2 dates
 

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



"Bob Phillips" wrote:

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)

"Sloth" wrote in message
...
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)


"Sloth" wrote:

=INT(B1-C1)

you will have to format the cell as a number after putting in the
formula.

"Linda RQ" wrote:

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

Days between 2 dates
 

So, what's the answer for the example you give, Linda?

"Linda RQ" wrote:

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