Outdate alert

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob P - 11 Apr 2008 23:30 GMT

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

Reply to this Message

Dave Peterson - 12 Apr 2008 00:47 GMT

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

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

Signature

Dave Peterson

Reply to this Message

Shane Devenshire - 12 Apr 2008 05:47 GMT

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

Reply to this Message

Rate this thread: