Custom Date formula needed

I need a formula that returns true is the date in cell C1 is in the next 4
weeks. The catch is this week can not count. So, if today is 7 june 05. I
need the code to be true if the date in C1 is between 12 June 05 ~ 9 July
05.

Try:

=AND(C1>TODAY()+7-WEEKDAY(TODAY()),C1<=TODAY()+35-WEEKDAY(TODAY()))

--

Vasant


"Yogi_Bear_79" <[email protected]> wrote in message
news:[email protected]...
> I need a formula that returns true is the date in cell C1 is in the next 4
> weeks. The catch is this week can not count. So, if today is 7 june 05. I
> need the code to be true if the date in C1 is between 12 June 05 ~ 9 July
> 05.
>
>