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.
|