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

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

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