| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duration days | Excel Discussion (Misc queries) | |||
| Repete Dates at a value of 28 days, 56 & 84 | Excel Worksheet Functions | |||
| need help with formula | Excel Discussion (Misc queries) | |||
| convert dates to number of days | Excel Worksheet Functions | |||
| Brainteaser about Days Between Dates | Excel Discussion (Misc queries) | |||
Linear Mode
