I need excel to look for dates in column A 14 days before the date in my calendar if there's a F in the next column add the product name to calendar

Question

enter image description here

I have tried a VLOOKUP, Index and Match, =if I think it may be a combination of them I just need pointing in the right direction. I have attached the image of my spreadsheet. The aim is that the calendar can populate its self as I will be adding data daily.