Posted to microsoft.public.excel.newusers

Bob P[_2_] Bob P[_2_] is offline

external usenet poster

Posts: 5

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AUTO OUTDATE	Bob P	Excel Discussion (Misc queries)	6	April 11th 08 11:54 PM
alert	Brian	Excel Discussion (Misc queries)	0	December 21st 06 06:52 PM
Message alert	laurenm	Excel Discussion (Misc queries)	6	December 19th 06 08:05 PM
Alert date	Bill	Excel Worksheet Functions	6	October 7th 06 02:37 AM
Rookie Alert-	kss	Setting up and Configuration of Excel	3	July 22nd 06 09:15 AM

All times are GMT +1. The time now is 10:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us