determine if date range falls within date

  • Thread starter Thread starter Dylan.L.Hunt
  • Start date Start date
D

Dylan.L.Hunt

Ok, this one is driving me crazy! Seems like it should be simple, but
no luck so far.

Here is what I've got:

a2 start date 2/10/06
b2 end date 1/29/06
c1 - aa1 dates by month ex 1/1/06 2/1/06, 3/1/06 etc...

Example
12 months exist between the start and end date, whenever the date
listed in cell c1-aa1 falls within the start and end date range the
value true is returned.

end result there will be 12 months with true and false whenever before
the start date and after the end date.
 
Dylan,

I assume that you have typo's/mixed upt your start/end dates.

Try in C2:

=AND(C1>$A$2,C1<$B$2)
copied along to AA2 by the fill handle

I will give you a series of TRUE/FALSE returns in C2:AA2

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top