Hi,
I am working on a Revenue forecast for Subscriptions. The Subscriptions can vary in length and can cover a full year to a number of days, and also overlap years.
I’ve made a start on a template and would like to populate cells E4:AB33 with Revenue attributable to each month. The top row is easy, and I can just divide D4 by 12. Then I get stuck. Row 7 for example. I would like revenue for the period (in each month) 03/03/2025 – 30/06/2026. Any formula help on populating this would be great.
As an additional add in, I’d like to be able to record the revenue even more accurately. For example:
The Revenue can only be earned Monday – Friday and no revenue is earned on UK Bank Holidays.
I’ve put the amount of working days in Row 2 and listed the Bank Holiday days from Row 37. (and below).
I am working on a Revenue forecast for Subscriptions. The Subscriptions can vary in length and can cover a full year to a number of days, and also overlap years.
I’ve made a start on a template and would like to populate cells E4:AB33 with Revenue attributable to each month. The top row is easy, and I can just divide D4 by 12. Then I get stuck. Row 7 for example. I would like revenue for the period (in each month) 03/03/2025 – 30/06/2026. Any formula help on populating this would be great.
As an additional add in, I’d like to be able to record the revenue even more accurately. For example:
The Revenue can only be earned Monday – Friday and no revenue is earned on UK Bank Holidays.
I’ve put the amount of working days in Row 2 and listed the Bank Holiday days from Row 37. (and below).
| UK Bank Holiday Days | |
| Wednesday | 01/01/2025 |
| Friday | 18/04/2025 |
| Monday | 21/04/2025 |
| Monday | 05/05/2025 |
| Monday | 26/05/2025 |
| Monday | 25/08/2025 |
| Thursday | 25/12/2025 |
| Friday | 26/12/2025 |
| Thursday | 01/01/2026 |
| Friday | 03/04/2026 |
| Monday | 06/06/2026 |
| Monday | 04/05/2026 |
| Monday | 25/05/2026 |
| Monday | 31/08/2026 |
| Friday | 25/12/2026 |
| Monday | 28/12/2026 |
