need to share value accross months in excel

Hello i am trying to create a formula to help me out with my work
what i have is a value for a job in cell I4 (say 10,000), this value needs to be shared over the dates of the job. so i have a cell with a start date in D4 and an end date in E4 now this job runs over say two months i need the value to be shared over the numer of days and the results cell only to show the value for that month

so for example

a job wortk £10,000 that starts on the 31st of december and end on the 1st of Jan would give me £5,000 in the a "december" total cell

hope that makes not to hard i have all ready got a cell that works out the number of days its just the end bit i have a problem with,

also tryiung not to make the document to big

where are the results being pushed ? ie where is the December cell etc...

It might be easier if you post up a small sample/example in .xls form so we can see your layout at least.

cu525, welcome to the Forum. Please take a few minutes to read the Forum Rules, then edit your Thread's Title - it should be descriptive of your problem, something like average daily costs.

to make your life as easy as possible I would first advise that in AH1:AS1 you enter the following formula:

AH1: =DATE(YEAR(AH3),MONTH(AH3)+1,0)
copy across to AS1.

This will give you the last day of each month.

Formula for AH4:AS8

=IF(COUNT($F4,$I4)<2,"",$I4*(MAX(0,1+MIN(AH$1,$E4)-MAX(AH$3,$D4))/$F4))