Hmmm nice thinking, simple and effective.

Id prefer to keep the spreadsheet in numerical order of the product number, thats why i was wondering if theres a way to select the expiry date columns and make the closest dates appear in other selected columns (other page or other part of same page).

but thank you, if i cant find what im looking for this is the best solution so far!