Maxicus
03-22-2018, 04:46 AM
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
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