View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Graham Graham is offline
external usenet poster
 
Posts: 155
Default formula to update dates periodically

I am creating a spreadsheet and one column will have a date established and
another column will have a follow-up date, which will be three weeks from
established date. Is there a formula to change the follow-up date every three
weeks and can it stop changing when the word "closed" is entered in another
column. The follow-up date already has a conditional format to turn red and
alert user that notices are due. The esatblish date is permanent.