With the range of dates that you are checking named "rng" ----How do I do this?

"Ron Rosenfeld" wrote:

On Fri, 26 Aug 2005 19:05:04 -0700, "Pe66les"
wrote:

I am tracking dates of service and I need to be able to see if dates fall
within a certain time frame.
column F Column H
row 1 (date 1) (date 2)


column H column J column L
(Client 1) date date date

I want to see if any of the clients dates fall between date 1 and date 2.
If any fall between these dates then count as 1 or true. If the dates are
before date 1 or after date 2, then I don't want to count them at all. The
problem is if I use date 1 and < date 2 then it counts everything before
date 1 as well. Please help me.


With the range of dates that you are checking named "rng" (you can substitute a
cell reference for this):

=MIN(1,COUNTIF(rng,"=" & date1) - COUNTIF(rng,"" & date2))

date1 and date2 may be cell references also.


--ron