umer_4teen
New Member
- Joined
- Nov 30, 2021
- Messages
- 1
- Platform
- Windows
I am trying the break annual revenue into a monthly spread.
Below is an example of the annual bookings from an account. I need a formula that would cater to the bookings spread over multiple months, and the tenure of each booking would overlap one another.
e.g July booking would spread over 12-month tenure i.e. July to June next year. Similarly, the Nov booking (in the negative) will spread from Nov till Oct next year.
I need a formula which would automate this
Below is an example of the annual bookings from an account. I need a formula that would cater to the bookings spread over multiple months, and the tenure of each booking would overlap one another.
e.g July booking would spread over 12-month tenure i.e. July to June next year. Similarly, the Nov booking (in the negative) will spread from Nov till Oct next year.
I need a formula which would automate this