Calculate % of total based on date criteria

Sorry, Im not sure Im understanding you.

Are you saying that you calculate a value under each month if that month is equal to or greater than the start month? ie if its April then you'd have zero in Jan, Feb, Mar but then values in April onwards?

if so then

Please Login or Register  to view this content.

in C3 and copy across

Is your calc then just the monthly % multiplied by the original amount? (the above assumes this) or are you spreading the original 100k over however many months? ie divide by 12 if January, 9 if April etc?

Try this.....

In C3

Please Login or Register  to view this content.

and then copy across.

Is this what you are trying to achieve?

I understand this to mean that the entire dollar amount has to be distributed across whatever months remain in the year. What I have done is to distribute the amount over the remaining months keeping the percentages in the same proportions. For example, suppose we have $100 to be spread over two months, that have percentages of 25% and 50%. That only adds up to 75%. The first month is 1/3 of that, and the second month is 2/3, so that's how we allocate the money--$33.33 and $66.67.

See attached.