View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tmv tmv is offline
external usenet poster
 
Posts: 2
Default insurance renewal formula flag needed

I need to flag a reminder for myself a couple weeks in advance to renew
insurance policies. How do I set this up if:

C1 D1 E1
Jane doe insurance exp.date "renew insurance"

I need the formula in column E. I can get it to remind me on the day it's
due only. I need it to pop up at least two weeks in advance and maybe stay
on for a couple days after????

Any help is appreciated, thanks