Working out difference between dates and more

[emsy40]

Hello all,

I need to produce a formula that can do the following, hopefully you can help....its quite difficult to explain so hopefully you can understand my poor explanation!

the spread sheet will have columns with descriptions of the 2010, 2011, 2012, and so on. above this will be some information for the formula to use which is....
1. a date (use 01/06/2010 for now) this date will change as and when required by the user.
2. £25
3. £50
4. 30,000 (this again will change as and when the user wishes too)

now want i want is to under each column date have a formula that magically looks at the date in 1. and works out how many months there are before this date to the beginning of the year stated at the top of the column and also how many from that date to the end of the year stated at the top of the column. next i need it to take the number of months before the date by 2. and then times the number of months after the date by 3. and add together

i am happy if i can get this far as the next stage still hasn't been made clear to me as to what is required but its likely to be either that the total of above then has to be mulitplyed by 4. OR take the answer the answers to above before adding together i.e. months x 2. and months x 3. are then multiplyed by two different figures then added together (hope that makes sense)

i am normally quite good at solving these kind of problems but cant seem to get my head round this one.....would appreciate some help.

Thanks everyone

Emma