Hi Vikas, thanks for responding. Unfortunately, that formula returned a value of 0. I'd like it to count 3 (Charles, Sam and Donna) as the people active on 7/1/2014, and when I run the formula for the people active in July, I'd like it to pick up 4 (those three people and Kate).

I hope that helps clarify the issue.