purchased vs invoiced days duplicates values

[Costin Calin]

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).

Can anybody help me with this issue ?

Many thanks,
Costin Calin

 

[Caribeiro77]

Where is the file?

 

[Costin Calin]

To my shame I do not know where to attach files or do I have permission to attach files...

 

[Caribeiro77]

Use dropbox links....

 

[Costin Calin]

Hello Caribeiro77,

Below you can find the link with my issue :

https://www.dropbox.com/s/7c05s15bx...ced days duplicates values - INDEX MATCH.xlsx

Regards,
Costin