I presume you have the 12 months in columns E to P, with your C/FWD in
column Q, and that your data begins in row 2. Put this formula in E2:

=IF(OR(MONTH($A2)COLUMN(A$1),MONTH($A2)+$C2-1<COLUMN(A$1)),0,$D2/$C2)

and copy this across into F2:P2. Then copy E2:P2 down for as many rows
as you have. In Q2 you can enter this formula:

=D2-SUM(E2:P2)

and copy this down. Format the cells in E:Q as currency.

Hope this helps.

Pete

On Nov 14, 11:21 am, Finance Guru
wrote:
FROM TO PERIODS COST JAN FEB MAR APR C/FWD
£GBP
01/08/2007 31/07/2008 12 8,956.00
10/02/2007 09/02/2008 12 27,443.00
05/05/2007 15/10/2007 5 2998.63
Hello,
I am trying to find a function that will do the following
Based on the month in the from Column ( eg. 08 )spread the cost (8,956) over
the periods(12) and where the periods exceed Dec ( Calendar year ) put the
the unallocated amount in C/Fwd col. Based on the Month in the From Column
it should start to populate the column respective to the start month eg.
01/08/2007 would start in the colum headed August,the start month eg.
05/05/07 would start in the column headed May,and so on.

I know the talent is out there .. but can anyone assist. I am running Excel
2003
Many thanks in advance