List of more then 3 months old Purchase Orders (PO)

[Salamullah]

I have a list of POs in sheet 1 contained 20 columns with its information and date is in column F.

I need list of more than 3 months old POs in Sheet 2 from row 2, in A1 Date with formula =TODAY().

Please help with formula

Sheet 1
Supplier No. Supplier Name PO No PO Type Date Amount Quantity
10001 DDD 12 Z 01/01/19 24,000 24
10002 SSS 13 Z 01/03/18 23,000 10
10001 DDD 14 Z 31/05/19 25,000 20
10002 SSS 15 R 14/10/17 14,000 30
10003 EEE 34 R 23/04/19 23,000 30

Sheet 2
01/06/2019
10001 DDD 12 Z 01/01/19 24,000 24
10002 SSS 13 Z 01/03/18 23,000 10
10002 SSS 15 R 14/10/17 14,000 30

 

[kweaver]

It's difficult to tell which heading goes with which data item.

 

[kweaver]

If I figured it out, you could use this formula filled down and across:

=IF(Sheet1!$E2<=Sheet1!$A$1-3*31,Sheet1!A2,"")

Then, filter based on column A for non-blanks.

HTH