View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rosemarie Rosemarie is offline
external usenet poster
 
Posts: 8
Default Formula to calcuate next rate increase in #weeks

Thank you!! Thank you!! Why couldn't I think of that.

"MyVeryOwnSelf" wrote:

How do I create a formula that will automatically calculate the next
rate increase that could be 15 weeks from last rate increase (example
1/7/2009 +15 weeks =?).


In Excel, a date is just a number of days from a certain starting point. It
looks different because formatting is applied, but it's a number for the
sake of calculations.

So if A1 contains any date, 15 weeks later is
=A1+15*7

Hope this helps getting things started.