Shelf Life Percentage between dates.

[TopherJH]

I'm looking for a formula that tells me how much percentage of a shelf life is remaining on a product.

Example:
DOM: 01/29/2015
DOE: 07/22/2016
Shelf life remaining based on todays date: 80.71%

Also, we have some products that have shelf life based on Date of Shipment from them.

Example:
DOS: 07/08/2015
DOE: 07/08/2018
Shelf life remaining based on todays date: 99.45%

Would like to incorporate both. So if a products shelf life is based on DOM, we would just enter the DOM and DOE, but if the product is based on DOS, we would just enter the DOS and DOE.

Any help would be appreciated.

Chris

[nigelbloomy]

Would this formula work if the setup was like the attached spreadsheet?

Please Login or Register  to view this content.

[TopherJH]

I think that will work.

Thanks a lot for your help!

Chris

[nigelbloomy]

You are welcome. Glad it helped.