We have products with expiration dates and we need a cell to count them in a range of days.
We have a column with expiration date that is put in manually by an employee with the rest of the data when received. Currently we have conditional formatting to highlight the products expiring within 30 days via the row turning yellow. We need a cell that will automatically count and display a value for all yellow (expiring within 30 days) and ignore already expired (red) products. Can this or something similar be done? Thank you in advance for any help.
Help Article Resources
Check out the Formula Handbook template!