This may be too complicated to explain without showing the financial
spreadsheet...but here goes.

Firstly I have a start date column and end date column for Projects. There
is also a contribution column which shows the total amount of contribution
for that project (e.g. £5,900). Lastly, I have 4 columns which are the
financial years (05/06, 06/07 etc) which at the moment are blank.

I want to create a formula that checks the start and end date and then
apportions the contribution across the financial years.

e.g if the start date and end date was 01/09/05 and 01/09/2006 respectively
and the contribution was £2000 i want a formula in the financial year columns
that splits the money into the relevant year. in this case £1000 in the
05/06 column and £1000 in the 06/07 column.

Can it be done?