Hi

I Hope someone can help.

I have a sheet (Sheet2) with data that has been completed throughout many years.

ID NAME DATE AREA EVENT
1 John 2018/02/22 East Rate1
2 Dwayne 2016/05/05 East Rate2
3 Jason 2017/06/01 West Rate2
4 Frank 2014/04/04 South Rate4

I need a code that will search the range (Sheet2 Column C "Dates") for any data exactly older than 365 days from a date entered in Sheet1 cell A1.

so if for example the date entered into sheet1 cell A1 was 2018/03/22 then the following data will appear on sheet3:

ID NAME DATE AREA EVENT
1 John 2018/02/22 East Rate1
3 Jason 2017/06/01 West Rate2