First time Posting

Hello all. My name is Jenny and this is my first time posting a problem.

I browsed through old posts, but did not find anything similar to my situation.

My Source file will feed into my Formula file (attached)

I need my formula to return blank when the dates from/to are not within those dates range.

For instance, 4/27 - 5/6, then my next set is 5/11 - 5/20. The gap in dates will be 5/7, 5/8, 5/9, and 5/10.

Since those dates are missing, I want the formula to return blank or n/a or something. Currently, the value returns with the previous row, column D.

Thank you for any help possible!!!! Have a great day.