Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count the no.of records between two dates
I need help on Some Excel functions that can help me to solve above subject.
I am creating a testing template . In which i have to count the no.of records that comes between two days. eg. 10/29/2004 & 10/30/2004. I am looking for your suggestion. Thanking you Sachin Pawar. |
#2
|
|||
|
|||
Sachin
=COUNTIF(A:A,"<=10/30/2004")-COUNTIF(A:A,"<=10/29/2004") Regards Trevor "Sachin Pawar" <Sachin wrote in message ... I need help on Some Excel functions that can help me to solve above subject. I am creating a testing template . In which i have to count the no.of records that comes between two days. eg. 10/29/2004 & 10/30/2004. I am looking for your suggestion. Thanking you Sachin Pawar. |
#3
|
|||
|
|||
try this where a1 and a2 contain your start/stop dates
=sumproduct((rngA=a1)*(rngA<a2)) -- Don Guillett SalesAid Software "Sachin Pawar" <Sachin wrote in message ... I need help on Some Excel functions that can help me to solve above subject. I am creating a testing template . In which i have to count the no.of records that comes between two days. eg. 10/29/2004 & 10/30/2004. I am looking for your suggestion. Thanking you Sachin Pawar. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
How do a count dates? | Excel Discussion (Misc queries) | |||
How do a count dates? | Excel Discussion (Misc queries) |