find dates between in excel
With names in Column A, and dates in Column B, one way would be to enter a
name to count in C1, and the number of the month (Jan=1, Feb=2, ... etc.) in
C2, and try something like this:
=SUMPRODUCT((A1:A50=C1)*(MONTH(B1:B50)=C2))
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"MDI Anne" wrote in message
...
I have 2 columns of data: one is name, the other is dates.
BOB 5/1/2007
STEVE 4/19/2007
JOHN 3/22/2007
MARY 7/21/2006
KATHY 5/4/2007
BOB 10/7/2006
STEVE 5/22/2007
MARY 5/14/2007
MARY 3/7/2007
MARY 5/30/2007
KATHY 1/5/2007
JOHN 5/15/2007
BOB 5/25/2007
STEVE 5/13/2007
BOB 5/1/2007
STEVE 4/19/2007
JOHN 3/22/2007
MARY 7/21/2006
KATHY 5/4/2007
BOB 10/7/2006
STEVE 5/22/2007
MARY 5/14/2007
MARY 5/30/2007
KATHY 1/5/2007
JOHN 5/15/2007
BOB 5/25/2007
STEVE 5/13/2007
I'd like to know how many times each name shows up in the month of May (or
whatever month I'm looking for). So, if I need a "findbetween" or some
other
formula, I would love some help.
Thanks all, in advance!
|