How do I use the IF formula to flag me 21 days after the date?

's Computer Specifications

I need to set up a spreadsheet that will flag me when it is 21 days past the
date I input originally.

's Computer Specifications

Wanderer --

Howze about:

A
1 Date
2 =IF(TODAY()-A1>21,"Holy cow!","")

Should do the trick. HTH

"Wanderer" wrote:

> I need to set up a spreadsheet that will flag me when it is 21 days past the
> date I input originally.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
i need the date to flag up red if it goes over 30 days from the d.	=?Utf-8?B?UGFsaQ==?=	Microsoft Excel Misc	6	25th Apr 2007 01:52 PM
How do I use the IF formula to flag dates 21 days prior to deadlin	=?Utf-8?B?V2FuZGVyZXI=?=	Microsoft Excel Worksheet Functions	1	26th Sep 2006 01:29 PM
flag date within a cell after 15 days have past?	=?Utf-8?B?U0FVRElB?=	Microsoft Excel Worksheet Functions	2	19th Aug 2005 04:33 PM
formula to find and flag dates older than 30 days	=?Utf-8?B?V2lsbCBHLg==?=	Microsoft Excel Worksheet Functions	1	18th Jun 2005 12:13 AM
Having a due date flag in a different colour 30 days from current.	=?Utf-8?B?bWlrZTA5OQ==?=	Microsoft Excel Worksheet Functions	1	20th Jan 2005 03:34 AM