Countif

[Jamie]

Simple one for you guys/girls I expect.

I have a list of dates for tenancy agreement start dates.
I need to find out how many of them started between the
2nd day and the 8th day. I can extract the day from the
date record by using DAY() but I am unable to count those
enties which fall between certain values. Does this
require an array formula?

Must be simple but I'm stumped.

Thanks in advance.

 

[Andy B]

Jamie

Try this:
=AND(DAY(A2)>=2,DAY(A2)<=8)
for data in cell A2 and fill down.

Andy.

 

[Peo Sjoblom]

One way

=SUMPRODUCT((DAY(A2:A10)>=2)*(DAY(A2:A10)<=8))