View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default How do I use the IF formula to flag dates 21 days prior to deadlin

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.