Ok, let me simplify it a bit because I am still not getting accurate results.
I have various dates in column J. I have a beginning date (constant) in A2
and an end date (constant) in B2. I want column J to be counted if it is
greater than A2 and less than B2. This should be simple, but I am getting
only 0's.

I've tried this formula...doesn't work.

=SUMPRODUCT(--(J21:J107A2),--(J21:J107<B2))

"Max" wrote:

To convert all "dates" in RQTS into real dates at one go, use DataText to
Columns. In step 3 of the wizard, check "date", then select the appropriate
format from the droplist, eg: MDY. Click Finish.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---