ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number of records between dates (https://www.excelbanter.com/excel-discussion-misc-queries/88029-number-records-between-dates.html)

flow23

Number of records between dates
 
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

Number of records between dates
 
=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)

"flow23" wrote in message
...
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






All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com