hi all
Please Login or Register to view this content.
In the attached file, we have a total of 4 price waves. The above formula works great, however, we have NOW plugged a date for each respective price wave.
The price increase will still be cumulative. So the first wave can start 1-July-22 at 9.7%, then user inputs 1-Dec-22 at 5% for 2nd wave etc. It is also dependent on the frequency "column K".
The formula in cell AU15 is based on single "effective date" in column M, but need help to modify it to add the effective dates for the respective price waves (new effective dates in column O, Q, S)
pls see attached. can someone kindly help pls?
thxs so much
Bookmarks