Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-18-2015, 12:05 PM
Emperor Emperor is offline Expiry Date Excel sheet! Windows 7 64bit Expiry Date Excel sheet! Office 2010 64bit
Novice
Expiry Date Excel sheet!
 
Join Date: Oct 2015
Posts: 3
Emperor is on a distinguished road
Lightbulb Expiry Date Excel sheet!

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!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Expiry Date Excel sheet! macro to automatically date sheet tab Jackie Excel Programming 13 05-24-2015 02:36 PM
Expiry Date Excel sheet! Expiry date in excel splinter09 Excel 3 12-10-2014 06:09 AM
Excel pivot table with a DATE value field for some reason stops at a certain date angie450 Excel Programming 2 08-19-2014 08:50 AM
How to fetch data from one sheet to another with complete details and date wise as well harisjawed86 Excel Programming 1 08-05-2014 09:10 PM
Letter date changes when merging with Excel - not the format, the actual date! Smallweed Mail Merge 1 02-07-2014 06:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft