Calculate time before expiration date (3 formulas)

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: [Calculating the days remaining before an expiration date]( [[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 [View this email in a browser]( [Exceljet Logo]( Exceljet P.O. Box 4804 Salt Lake City, UT 84110 Copyright © 2024 Exceljet, All rights reserved. You received this email because you are subscribed to our newsletter. To unsubscribe, click the link below. [Unsubscribe](