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