quarterly calcs from month numbers

ringojb

New Member
Joined
Oct 24, 2019
Messages
2
I've been asked to calculate quarterly dollar spread based on start and end months.

I need it in this format.

removed bad image

Q1 calc is easy, but gets complicated (for me) on the rest. Any help would be greatful. Thank you.

start monthend monthtotal costq1q2q3q4
37500000calccalccalccalc
need these results100000300000100000

<tbody>
</tbody>
 
Last edited by a moderator:

Tetra201

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,485
See if the following formula works for you:

=$C2/($B2-$A2+1)*MAX(0,MIN($B2,RIGHT(D$1)*3)-MAX($A2,RIGHT(D$1)*3-2)+1)
 

Forum statistics

Threads
1,085,546
Messages
5,384,375
Members
401,892
Latest member
martyg

Some videos you may like

This Week's Hot Topics

Top