RE: How do I calculate if a date is in a certain time frame?
 From: "Pe66les" <Pe66les@xxxxxxxxxxxxxxxxxxxxxxxxx>
 Date: Sat, 27 Aug 2005 02:01:01 0700
WOOOHOOOO!!!!! I did it!!!! I used:
=3COUNTIF(H5:L5,">="&$H$1)COUNTIF(H5:L5,"<="&$F$1)
It worked!!!!! Thank You so much for helping me figure out what I needed
to do!!!
"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.
.
 FollowUps:
 References:
 How do I calculate if a date is in a certain time frame?
 From: Pe66les
 How do I calculate if a date is in a certain time frame?
 Prev by Date: how to get the name of the sheet in a cell?
 Next by Date: Re: cover #s to text
 Previous by thread: Re: How do I calculate if a date is in a certain time frame?
 Next by thread: RE: How do I calculate if a date is in a certain time frame?
 Index(es):
Relevant Pages
