Home |
Search |
Today's Posts |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
counting occasions dates occur between 2 dates
thanks Trevor
"Trevor Shuttleworth" wrote: Or, you could get away with: =SUMPRODUCT((C4:C254=B7)*(C4:C254<=B8)) Regards Trevor "hoyt" wrote in message ... thanks for the help Trevor i think ive done it the way i wanted by altering your formula a little to: =SUMPRODUCT((C4:C254=VALUE(B7))*(C4:C254<=VALUE(B 8))) "Trevor Shuttleworth" wrote: Assuming your dates are in cells A1 to A1000: =SUMPRODUCT((A1:A1000=DATE(2006,6,6))*(A1:A1000<= DATE(2006,6,18))) Regards Trevor "hoyt" wrote in message ... i have a column which shows the date that a task is complete, what i want is a formula to show how many times the task has beem completed in a week. for example if the column had the date 12/6/6 three times and the date 15/6/6, seven times then between 12/6/6 & 18/6/6 the task has been completed ten times. is this possible, any ideas? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting non-repeating dates | Excel Discussion (Misc queries) | |||
Counting Dates | Excel Worksheet Functions | |||
Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
Counting individual dates | Excel Discussion (Misc queries) | |||
counting entries between two dates? | Excel Worksheet Functions |