Outdate alert

  • Thread starter Thread starter Bob P
  • Start date Start date
B

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","")
 
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";"")
 
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
 
Back
Top