I have a very nifty macro that DMille wrote for me that allows you to put in a "Time Horizon", as a number of months and it auto generates the date fields and copies the monthly calculation formulas into each litigimate month. This is used to allow someone to determine how many months are to be included in a financial analysis to calculate NPV, IRR and BEP. Here's the challenge. The formulas for NPV and IRR need to be reconfigured to automatically adapt to the number of months selected in the Time Horizon (since it is now dynamic).
Attached is the WS. The formulas that need modification are in AF3 and AF4 (right now they are fixed at 36 months).