Inventory - First In First Out

T

tlcGRE

Is there a way to set up a spreadsheet that shows a running balance of an
item that has an expiration date? Each item has a shelf life of 5 years,
current year + 4.
Any help will be greatly appreciated.
 
S

Sean Timmons

so you want to see how many years or months or days are left?

i assume you have date added. Let's say it's in cell C1 for your first product

so

=DATE(YEAR(C1)+5,MONTH(C1),DAY(C1))-now() will give number of days. between
now and the 5 years are up.

otherwise, just divide by 30 to get months or 365 to get years.
 
Top