Custom Date formula needed

Y

Yogi_Bear_79

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.
 
V

Vasant Nanavati

Try:

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