របៀបគណនាចំនួនថ្ងៃផុតកំណត់និងបង្ហាញការផុតកំណត់ក្នុង Excel - How to Calculate Expire Date and Show Expire Status in Excel (video)

Hello everyone! Today I show you very easy step-by-step how to calculate expire date, check remaining days, and show expire status in Excel. When you manage product stock, food inventory, or membership list, this trick help you track expired items very easy!

🛠️ Easy Step-by-Step Formula

Step 1: Calculate Expire Date from Manufacturing Date

If you have Production Date in Cell A2 and Shelf Life (Days) in Cell B2, write this simple formula:

=A2 + B2

💡 Tip: If shelf life count by Months (example: expire after 6 months), use EDATE formula =EDATE(A2, 6) instead of manual days!

Step 2: Calculate Days Remaining Until Expire

To check how many days left before expire (Expire Date in Cell C2):

=C2 - TODAY()

Excel will subtract today's date automatically. If result is positive number (like 15), it mean 15 days left. If result is negative number (like -3), it mean already expired 3 days ago!

Step 3: Show Expire Status Automatically (IF Formula)

To display status text like "Expired", "Expire Soon", or "Active", use this IF formula:

=IF(C2 < TODAY(), "Expired", IF(C2 - TODAY() <= 30, "Expire Soon", "Active"))

💡 Pro Tips

1. Auto Update Current Date: Always use TODAY() formula. Excel auto update remaining days every time you open your file!
2. Highlight Expired Cell with Color (Conditional Formatting):
   • Select your Status column.
   • Go to Home tab -> Conditional Formatting -> Highlight Cells Rules -> Text that Contains...
   • Type Expired and choose Light Red Fill.
   • Type Expire Soon and choose Yellow Fill.
3. Hide Negative Days: If you don't want to show negative number for expired items, wrap with MAX formula: =MAX(0, C2 - TODAY()).