type this in g1
=SUM(IF(F1>=DATE(YEAR($B$1:$B$14),MONTH($B$1:$B$14),1),IF(F1<=DATE(YEAR($C$1:$C$14),MONTH($C$1:$C$14),1),1,0)))
and press ctrl +shift =enter
see if it helps
On Fri, May 15, 2015 at 12:10 AM, Heather Battle
wrote:
> that's correct
>
> On Thursday, May 14, 2015 at 1:13:52 PM U
that's correct
On Thursday, May 14, 2015 at 1:13:52 PM UTC-4, ashish wrote:
>
> just wanted to check even if the some one is active just for a day in a
> month like start date is 1 jan 2014 and end date is 2 jan 2014 will that
> be counted as active in jan month
>
>
> On Thu, May 14, 2015 at 1
just wanted to check even if the some one is active just for a day in a
month like start date is 1 jan 2014 and end date is 2 jan 2014 will that
be counted as active in jan month
On Thu, May 14, 2015 at 10:37 PM, Heather Battle
wrote:
> I have a spreadsheet where i have participants that enro
