Hi,

You can use this criterion. Assuming your control date is in B2 and
your column header is Date

Then
C1:E1 : Date
C2: ="="&DATE(YEAR(B2),MONTH(B2),1)
D2: ="<"&DATE(YEAR(B2),MONTH(B2) + 1, 1)
E2: ="<"&B2

Then specify C1:E2 as the criterion.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=546280