Assuming the items are in column A and the expiry date is in column B, and
the alert will be outputted to column C, put this formula in column C.

=IF(B1-TODAY()<30,"ALERT","")





"Bob P" wrote:

I want to create a file that has the name of items and their expiration date
but would like to set so I get an alert a month before the item expires. Is
that possible with excel? If so where can I find information in how to
configure the file to do this??