Counting dates within a period of time

I am working on a formula to count how many times a date appears with a certain period of time, see what I have done so far
=SUMPRODUCT((F3:H3>Dates!A4)*(F3:H3<Dates!B4))

rather than have it check for dates between F3:H3 i need it to check F3, J3, N3, Q3 for the dates that fit the criteria however when i do it like this
=SUMPRODUCT((F3,J3>Dates!A4)*(F3,J3<Dates!B4))
it keeps coming up with #Value! when it should actually be 2

Any help on this would be great.

Thanks in advance


Justin.

I have re submitted this question.

Hi Ron,
Thanks so much for replying, it works brilliantly!


Thanks again



Justin.

Hi there,
Ron previously replied to this question.
I want to make a change to this formula but not sure how, =INDEX(FREQUENCY((F3,J3,N3,Q3),Dates!A4:B4-{1,0}),2)

Rather than the formula adding up the amount of times a date appears in the cells above, If a date appears in any the cells above I want it to read the name that is in B3 and display it in AB3
If anyone can help it would be much appreciated.

Thanks


Justin.

I assume you mean that if any one or more of F3, J3, N3 or Q3 are within the required date range you want B3 to appear? If so you should be able to enclose Ron's suggested formula in an IF function, i.e. in AB3

=IF(INDEX(FREQUENCY((F3,J3,N3,Q3),Dates!A4:B4-{1,0}),2),B3,"")

Thanks daddylonglegs, exactly what I am looking for.


Cheers


Justin.