On Tue, 23 Aug 2005 17:50:03 -0700, "Pe66les"
wrote:

How can I write this expression so that my answer is not #VALUE?
I'm working with dates, and I want to count only the dates in columns H, J,
& L if they fall between the dates entered in F1 and H1.
IF H5 or J5 or L5 is F1 and <=H1 count as 1.

I'm not sure if you want to count each qualifying date as 1 (so your result
range would be 0 to 3) or count 1 if any of the dates qualify (so your result
range would be 0 to 1)

For the former:

=AND(H5F1,H5<=H1)+AND(J5F1,J5<=H1)+AND(L5F1,L5< =H1)

For the latter:

=--OR(AND(H5F1,H5<=H1)+AND(J5F1,J5<=H1)+AND(L5F1,L 5<=H1))


--ron