Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting occurrences by date
Good morning:
I need some help with the following. I have a range of dates in the format MM/DD/YY and need to count occurrences by day, current week and current month. Any help would be greatly appreciated. -- Thanks, Larry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting occurrences by date
this day =COUNTIF(A2:A200,TODAY()) this week =SUMPRODUCT(--(A2:A200=TODAY()-WEEKDAY(TODAY())+1),--(A2:A200<TODAY()-WEEKDAY(TODAY())+8)) this month =SUMPRODUCT(--(MONTH(A2:A200)=10)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "lwilliams" wrote in message ... Good morning: I need some help with the following. I have a range of dates in the format MM/DD/YY and need to count occurrences by day, current week and current month. Any help would be greatly appreciated. -- Thanks, Larry |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting occurrences by date
Hi Bob:
Thanks for the answer. Seems like you are the one who always helps me. I do appreciate it. -- Larry "Bob Phillips" wrote: this day =COUNTIF(A2:A200,TODAY()) this week =SUMPRODUCT(--(A2:A200=TODAY()-WEEKDAY(TODAY())+1),--(A2:A200<TODAY()-WEEKDAY(TODAY())+8)) this month =SUMPRODUCT(--(MONTH(A2:A200)=10)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "lwilliams" wrote in message ... Good morning: I need some help with the following. I have a range of dates in the format MM/DD/YY and need to count occurrences by day, current week and current month. Any help would be greatly appreciated. -- Thanks, Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting occurrences with conditions | Excel Discussion (Misc queries) | |||
Counting occurrences | Excel Discussion (Misc queries) | |||
Counting occurrences | Excel Discussion (Misc queries) | |||
Counting occurrences on a particular date | Excel Worksheet Functions | |||
Counting number of occurrences | Excel Worksheet Functions |