![]() |
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 |
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