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