Enter cell value if between start and end date

[DSM2019]

Hello!
I'm trying to figure the best way to enter a percentage if falls between a start and end date. Example: If start date is 1/1/2019 and end date is 4/20/2019, and percentage value is 20, I want the columns for 1/1/2019-4/1/2019 to show 20% and if outside those dates, show "No Estimates".
I've tried several different IF MONTH/YEAR formulas, but I haven't been able to get it to work (especially if the start or end date is not in the same year).
I've attached a file of my current test and mock-up of what I'm trying to accomplish. I'm open to other ideas outside of formulas as well (if they exist)
Any advice is GREATLY appreciated!

 

[Luke M]

Formula in D3:
=IF(MEDIAN(D$8,$A3,$B3)=D$8,$C3,"No Estimate")

 

[Juniad]

Try this formula in D3 cell.
=IF(AND(D2>=$A$3,D2<=$B$3),$C$3,"No Estimate")

 

[Juniad]

Sorry for the cell references it was lock
try this one..
=IF(AND(D$2>=$A3,D$2<=$B3),$C3,"No Estimate")

 

[bosco_yip]

Or….............

=IF((D$2>=EOMONTH($A3,-1)+1)*(D$2<=$B3),$C3,"No Estimate")

Regards
Bosco

 

[DSM2019]

Thanks everyone for your help. I was able to get it to work using Luke M's formula. I greatly appreciate all your assistance!