Counting occurrences by date

[lwilliams]

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.

 

[Bob Phillips]

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]

Hi Bob:

Thanks for the answer. Seems like you are the one who always helps me. I
do appreciate it.
--
Larry

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)