If formula- can anyone help?

[Smiler]

i'm having an utter nightmare remembering how to solve this

i have the following

value being a, date from b and date to c

Value  Date From     Date to
£5000   30/04/08    31/09/08
£2450   30/09/08    30/10/08
£7500   14/03/09    23/05/09
£9000   22/03/08    31/06/09

i wanna have a formula that works out how much relates to

07/08 year - being 01/04/07 to 31/03/08 say in column d
08/09 year - being 01/04/08 to 31/03/09 in e
and 09/10 year - being 01/04/09 to 31/03/10 and f

i'm sure i've done summat like this before and know that it will involve working out the values per day to start with

can anyone help?