Percentage Allocation Formula not working

Hi all

I have a spreadsheet which contains a list of projects, each having a start date, duration, and then monthly allocation. A member of the community kindly provided me with a very smart (and very elegant!) formula which calculated the even percentage allocation across a period of months based on a specified start date and a duration (see file attached).

I have attached a stripped down version of the spreadsheet which contains a working example of this formula. However, it now seems to add another month onto each project. For example, if I specify 12 months, it now distributes the project across 13 months. 18 becomes, 19, etc.

I have tried to understand why, but have so far been unable to come up with a solution as to why this is happenning.

Any help would be greatly appreciated.

Many thanks in advance

Shaun

Hi NBVC

That has worked very well indeed, thank you very much!