Hi - Dave here.
Happy Friday!
All food products have expiration dates and you might want a simple way to track how much time remains before a product expires.
A perfect job for Excel :)
In this example, I provide 3 formulas that get the job done in different ways:
1. Calculate remaining time in days
2. Calculate remaining time in years, months, and days
3. Calculate remaining time as a percentage of shelf life
In the worksheet below, you can see the first approach:
[
Download the workbook and read the full explanation]
The article above explains all 3 formulas with links to related functions. Download the workbook and try it out yourself.
Note: This example will work in any Excel version.
Excel formulas
We maintain a list of over 500 working formulas
here.
If you need more structure, we also offer
video training.
Have a great weekend!
Dave
