Thread: Check date
View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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