Monitoring the comparison of two dates

[EMS Dana]

I work in the medical field. I would like to monitor the expiration date of
medical supplies. I want to compare the expiration date to the current date
then be alarmed, notified, alerted, e-mailed or some method of knowing the
expiration date has arrived.

 

[Paul Mathews]

Dana, just to be clear, do you have a worksheet that contains medical supply
data (e.g., description of medical supply, expiration date of supply)? If
so, is this worksheet updated (i.e., opened) on a daily basis? The reason I
ask is that there needs to be an event (like opening the worksheet) to which
we can associate the code that checks the supply expiration dates against the
current date. You could potentially have some code that automatically runs
each time the supplies worksheet is opened and provides you with a printable
summary list of all supplies that have expired (i.e., expiration date
precedes current date) or will expire within a short time (you can specify
the interval like 2 days for example).