On Monday, June 1, 2015 at 11:46:07 AM UTC+5:30, Claus Busch wrote:
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

Hi Claus,
This fixes my issue.
Thanks a lot !!