hi again,

Am Mon, 1 Jun 2015 08:04:30 +0200 schrieb Claus Busch:

in C2 try:
=IF(AND(EOMONTH($A2,-1)+1<=C$1,EOMONTH($B2,0)=C$1),"Yes","")

better try this:
=IF(AND(EOMONTH($A2,-1)+1<=C$1,$B2=C$1),"Yes","")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional