View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default How do I use the IF formula to flag me 21 days after the date?

Wanderer --

Howze about:

A
1 Date
2 =IF(TODAY()-A121,"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.