determine if date range falls within date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dylan.L.Hunt@gmail.com - 06 Sep 2006 17:34 GMT

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.

Reply to this Message

Sandy Mann - 06 Sep 2006 19:35 GMT

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

Signature

HTH

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

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> Ok, this one is driving me crazy! Seems like it should be simple, but
> no luck so far.
[quoted text clipped - 12 lines]
> end result there will be 12 months with true and false whenever before
> the start date and after the end date.

Reply to this Message

Rate this thread: