Number of records between dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=SUMPRODUCT(--(TEXT(D2:D20,"yyyymm")<="200601"),--(TEXT(E2:E20,"yyyymm")>="2
00601"),G2:G20)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count between start date and end date 5
How do I count cells in Excel between date values? 3
Excel Help with dates 2
Colour cell to return date 4
how do i convert a number of days to years, months & days? 1
How do I create a formula that gives number records with certain d 3
match one column with dates to several colums with dates, copy pas 4
Can's work this out, probably easy for an expert! 4

Back
Top