Trying to set up a file where I can list items in column a with their out
dates in column b and would like to set it up so I get an alert one month
before the outdate. I was given this formula but get an message that says
there is an error in it. any idea what is wrong.

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

Maybe you're not working with an English version of excel and have to change the
=IF() and =Today() to match the language you're using.

Maybe you have a list separator of a semicolon (;) instead of a comma (,).
USAians usually use commas and Europeans usually use the semicolon.

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



Bob P wrote:

Trying to set up a file where I can list items in column a with their out
dates in column b and would like to set it up so I get an alert one month
before the outdate. I was given this formula but get an message that says
there is an error in it. any idea what is wrong.

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

--

Dave Peterson

Hi Bob,

Cell B1 must contain a legal Excel date or be empty. If the entry is text
the formula will return an error, even if it looks like a date.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Bob P" wrote in message
...
Trying to set up a file where I can list items in column a with their out
dates in column b and would like to set it up so I get an alert one month
before the outdate. I was given this formula but get an message that says
there is an error in it. any idea what is wrong.

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