Outdate alert

[Bob P]

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]

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";"")

 

[Shane Devenshire]

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