How do I calculate escalation rates using dates and a set value

K

KenSouthfield

If I have a projected that needs to be escalated using start and completion
dates by a certain percentage per year, how do I write the formula. For
example if my project starts May 26, 2010 and lasts until may 26 2014 I want
to add escalation to midpoint at 4% per year.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I designate dates using info from a cooresponding drop down list? 3
how do i calculate percentage of change between two or more field. 3
calculate fractions using dates 6
Using contract start/end dates and calculating annual contract day 3
How do I calculate profit per hour in excel? 1
Need help writing query for min lease payments 2
How do I create 365 labels for 2009?? 3
how do I calculate a difference in dates in years and months? 20

Top