yogi_Compute Row By Row Number Of Days of Activity By Specified Client During a Speified Month

                                         Google Spreadsheet   Post  #1659
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-31-2014
post by romgl -- question by Polish user: (https://productforums.google.com/forum/#!mydiscussions/docs/O9TCwKC5fPs)

Hi Yogi,

Thanks for your reply. I will rephrase my question:

I am trying to find a formula, that can help me count the number of days a client was active in a chosen month, as shown in the test spreadsheet with the link below :

https://docs.google.com/spreadsheets/d/1vSUchCgbvTg7rC6S76GVtashzN0tZpE1lcHcUy7INoU/edit?usp=sharing

Thus, for example, in the link above, on the Client activity sheet, if I choose February, I should see the following results :

Client A   2

Client B   2

Client C   0

But if I select April, I should see the following :

Client A   1

Client B   0

Client C   0

Thanks again for your efforts in helping me with this.

------------------------------------------------------------------------------------------------------------------------------------------------