Formula HELP!!

I believe this is exactly what I was looking for. I was way over thinking how to write it. Thank you very much for the help!!

Tyler Smith , yes, in initial formula was "blank or, if date, in later month", I forgot to remove checking on blank. Check if text here or not also could be removed, only "within the month"

=SUMPRODUCT(
   ISNUMBER(SEARCH("Plan",$R$3:$BA$3))*
   ($R$4:$BA$34>=(EOMONTH(CQ4,-1)+1))*
   ($R$4:$BA$34<=EOMONTH(CQ4,0))*
   (OFFSET($R$4:$BA$34,0,1)>=(EOMONTH(CQ4,-1)+1))*
   (OFFSET($R$4:$BA$34,0,1)<=EOMONTH(CQ4,0))
)

I didn't check the source data if result is correct, please inform if something is wrong

This is almost what I am looking for, the only thing is that it is counting the items as "completed" before the actual column has been entered. Once the actual column had been entered it does work correctly.

So I would like it to look at the "Plan" Column and if it is due in that month, then look at the "Actual" column to see if that task was completed in that month. But like I said above I need it to not count anything in the "Plan" Column until a date has been entered in the "Actual" column. I hope this clears up what I'm trying to do.

I apologize for the confusion. 

SergeiBaklan 

Tyler Smith ,

Do you mean to calculate number of plans completed at the same month as planned? When it's only to adjust a bit second part of the previous formula

=SUMPRODUCT(
   ISNUMBER(SEARCH("Plan",$R$3:$BA$3))*
   ($R$4:$BA$34>=(EOMONTH(CQ4,-1)+1))*
   ($R$4:$BA$34<=EOMONTH(CQ4,0))*
   (ISBLANK(OFFSET($R$4:$BA$34,0,1))+ISNUMBER(OFFSET($R$4:$BA$34,0,1))*(OFFSET($R$4:$BA$34,0,1)>=(EOMONTH(CQ4,-1)+1)))*
   (ISBLANK(OFFSET($R$4:$BA$34,0,1))+ISNUMBER(OFFSET($R$4:$BA$34,0,1))*(OFFSET($R$4:$BA$34,0,1)<=EOMONTH(CQ4,0)))
)

I figured it would be easier for everyone instead of having to re explain the entire situation.Twifoo 

Hello,

I know I am reaching back a while, but I figured since I already have this thread and my problem has to do with the same problem i would continue it on. So my problem now is I need to Compare both of my columns (Plan , Actual), if the Plan has a date within a certain month, (lets say march), then I need the formula to look at the actual and see if it was also completed in the same month. 

Thank you for the help!

SergeiBaklan 

Okay I believer you have finally got it! Thank you so much for all the help, I would of never been able to figure out that formula on my own.