purchased vs invoiced days duplicates values

costi_linho12

New member
Joined
Jul 12, 2014
Messages
1
Reaction score
0
Points
0
Location
Bucharest, Romania
Excel Version(s)
16.0.13328.20262
Dear All,

I need you help me in order to find a correct formula who can return date between “Scan Date” and “Invoice date” from the attached file ?

Issue – I want to know how many days has past from Scan Date till invoice date (you can see that I have a lot of duplicates p/n in the file).

From Scan Date I need to return the Invoice Date - the invoice date must be ” =>” then Scan date, not “<”.

Can anybody help me with this issue ?

Many thanks,
Costin Calin
 

Attachments

  • purchased vs invoiced days duplicates values - INDEX MATCH.xlsx
    11.6 KB · Views: 14
Top