Try:

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

--

Vasant


"Yogi_Bear_79" wrote in message
...
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.