View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
charles charles is offline
external usenet poster
 
Posts: 124
Default help with a formula

I have the need to create a formula that calculates the number of months
between cell B3 and C3 then divide that number by the amount in cell A1 then
find the €śstart date€ť month and put the value for each month until the "end
date" is reached. I hope this makes since, and I appreciate any help you can
give me!!

1 A B C D E F
2 Amount start date end date Jan-07 Feb-07 Mar-07
3 $ 100,000 Feb-07 Sep-07

Thanks,
Charles