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
|