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

Salamullah

Board Regular
Joined
Mar 28, 2011
Messages
218
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

Well-known Member
Joined
May 8, 2018
Messages
868
Office Version
365, 2010
It's difficult to tell which heading goes with which data item.
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
868
Office Version
365, 2010
If I figured it out, you could use this formula filled down and across:

Code:
=IF(Sheet1!$E2<=Sheet1!$A$1-3*31,Sheet1!A2,"")
Then, filter based on column A for non-blanks.

HTH
 
Last edited:

Forum statistics

Threads
1,086,074
Messages
5,387,657
Members
402,072
Latest member
Nauef

Some videos you may like

This Week's Hot Topics

Top