Expiry Date Excel sheet!

[Emperor]

Hey all,

Im always amazed at the ability of humans to find solutions for problems and their ability to improve everything. Im looking for something like that here too.

I am a complete beginner when it comes to excel but it fascinates me with the things it can achieve.

currently i am working for a company that among other things sells food and stuff with an expiry date.

So far the way the company handles this is by having an excel sheet with the list of the products and a possible expiry date that i have to manually search per product. every month i get a new list that i have to check over again from scratch.

I wanted to make it a bit more interactive and progress a bit things by changing the sheet slightly... ok maybe not slightly... ill go Frankenstein on it.


Ok so heres what im thinking:
Ill have one excel page that includes
column 1: product number (easy to search the product by that in store)
column 2: product name and description
column 3: number of days close to current day (using the TODAY() function
Column 4-10 possible expiery dates (yes some products have maaaany expiery dates like Coka~Cola can have 3+ different per month)

After I complete the expiry dates on the columns 4+ i would like to create a space on another page, if possible, that shows all the dates that are 20 days or closer to today. (or at least the 20 closest expiery dates from the columns 4-10 of the first page)

Think thats possible?
Also any ideas of how to make it better are welcome


Thank you for taking the time to read through!