Copy cell if start and end dates are in current month

[MSDVA]

I want to enter a value from a cell if the start and end date fall within the current month. I've tried some if/and statements and other formulas, but I have been unable to get the solution for the below scenario:

Any help is greatly appreciated!

Start Date	End Date	Percent	January
1/31/2019	11/25/2019	20%	If A1 & B1 are within January then 20%

<tbody>
</tbody>

 

[silentwolf]

Hi,
=if(Month(A2)=Month(B2),20,0)

HTH

 

[MSDVA]

Thanks!

I was able to get it to work by modifying to this:

=IF(AND(MONTH($E44)&YEAR($E44)<=MONTH(K$10)&YEAR(K$10),MONTH($G44)&YEAR($G44)>=MONTH(K$10)&YEAR(K$10)), $J44,"No Estimate")

However I'm getting false positives when the start or end date is outside of the current year.

Any advice?

 

[Fluff]

How about
=IF(AND(EOMONTH(E44,-1)+1>=EOMONTH(K10,-1)+1,EOMONTH(G44,0)<=EOMONTH(K10,0)),"OK")