Create a list from information that is 300 days past a nominated date

Hi all

Is it possible to produce a list of products the are out of a date range; example
If column A:A=”Yes” and B:B=Date+300 days list C:C in cell F:F.

A:A is Yes, No
B:B is date (dd,mm,yyyy)
C:C is case number (ABC/12/00012)
F:F list of over due cases.

So basically if A:A is Yes and B:B is past 300 days then place corresponding information from C:C into F:F or F:1
Is this possible?

Cheers
Gatheringinfo

Hi and welcome to the forum

Not sure is this is exactly what you wanted, but I think it gives you wnat you wanted. I put this in D, copied down, but you could put it where ever you want...

=IF(B2+300<TODAY(),C2,"")

Sure, change the formula to...
=IF(AND(A2="Yes",B2+300<TODAY()),C2,"")