Expiry-date-reminder-in-excel-template May 2026

=IF(B2-TODAY()

This calculates the difference between the expiry date (Cell B2) and today's date. If it's less than 0, it's expired; if it's 30 days or less, it's a warning. 2. Visual Color Alerts (Conditional Formatting) expiry-date-reminder-in-excel-template

Use an IF formula to display whether an item is "Expired," "Expiring Soon," or "Active." if it's 30 days or less