Hi,
I have a list of 70 clients with contract amounts and start dates on one tab. I need to make projection for 12 months in a way that for each customer no more than 15,000 monthly revenues is included in the forecast. For instance if the contract amount is 42,000 USD then I should account for 15,000 first month, 15,000 second and 12, 000 last month. Can you, please, help me with the formula?
I have a list of 70 clients with contract amounts and start dates on one tab. I need to make projection for 12 months in a way that for each customer no more than 15,000 monthly revenues is included in the forecast. For instance if the contract amount is 42,000 USD then I should account for 15,000 first month, 15,000 second and 12, 000 last month. Can you, please, help me with the formula?