Check date
Using your formula:
FALSE Monday, February 28, 2011
FALSE Monday, March 07, 2011
He goes 8 weeks between "TRUE"'s.
Using <7 was a bad assumption on my part (I forgot that February 28th pushes
a full 7 days); however, using <8 should work though...
=(G3=DATE(YEAR(G3),MONTH(G3)-(DAY(G3)<8),28)+8-WEEKDAY(DATE(YEAR(G3),MONTH(G3)-(DAY(G3)<8),28)-1))
Rick
|