View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bert_lady bert_lady is offline
external usenet poster
 
Posts: 4
Default Project a date and calculate a % in one formula

See two colums below. My formula needs to calculate 60 days out from the
given date in Col A , then from that date give me an annualize 6% from the
caculated date until 11/16/09. I have beat my head against the wall on this
one. Thanks


Col A Col B
01/05/05 528.00
01/08/05 482.63
01/08/05 544.50
01/10/05 700.87


bert_lady