Bob,
It works for me. Is you're date formated as Date? or is it just text?

Can you describe the error a bit more?

Mike


"Bob P" wrote:

Mike thanks for you quick response however when I type that formula in the c
column I get a message that says there is an error. And Ideas what is wrong

"mike" wrote:

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??