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!

[TABLE="width: 203"]
<tbody>[TR]
[TD="width: 68, bgcolor: transparent"]Start Date[/TD]
[TD="width: 75, bgcolor: transparent"]End Date[/TD]
[TD="width: 64, bgcolor: transparent"]Percent[/TD]
[TD="width: 64, bgcolor: transparent"]January[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/31/2019[/TD]
[TD="bgcolor: transparent, align: right"]11/25/2019[/TD]
[TD="bgcolor: transparent, align: right"]20%[/TD]
[TD="bgcolor: transparent"]If A1 & B1 are within January then
20%

[/TD]
[/TR]
</tbody>[/TABLE]

 

[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")