How do I use the IF formula to flag dates 21 days prior to deadlin

's Computer Specifications

I am trying to set up a spreadsheet that will flag me 21 days from the date I
send out documents. So that I can follow up on those documents.

's Computer Specifications

What do you have so far? You could do this with conditional formatting or
something like this to define the date 21 days (calendar) out

=date(year(A1),month(A1),day(A1))+21

Or a combination of the two

"Wanderer" wrote:

> I am trying to set up a spreadsheet that will flag me 21 days from the date I
> send out documents. So that I can follow up on those documents.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
No of Days between two dates and offset formula	vmohan1978	Microsoft Excel Worksheet Functions	4	5th Jan 2010 04:57 AM
Function to return dates prior to inputed, or if null, prior to no	=?Utf-8?B?a2NzaW1z?=	Microsoft Access Queries	2	8th Nov 2006 10:00 PM
How do I use the IF formula to flag me 21 days after the date?	=?Utf-8?B?V2FuZGVyZXI=?=	Microsoft Excel Worksheet Functions	1	26th Sep 2006 12:50 AM
IF formula to flag exp dates	=?Utf-8?B?d2FzdGVkd2luZ3M=?=	Microsoft Excel Worksheet Functions	2	5th Aug 2005 12:51 AM
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