Number of records between dates

[flow23]

Colum D has start date and colum E has end date colum G has unique records
(1,0)

what I want is a list from this database saying how many members were active
in in a particular month
Jan 06 -- XX
Feb06- xxx
and so on

 

[Bob Phillips]

=SUMPRODUCT(--(TEXT(D220,"yyyymm")<="200601"),--(TEXT(E2:E20,"yyyymm")>="2
00601"),G2:G20)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)