Say Start date is in A2, end date in B2, volume in C2

month 1 volume:
=$C2/($B2-$A2+1)*(DATE(YEAR($A2),MONTH($A2)+1,0)-$A2+1)

month 2 volume:
=$C2/($B2-$A2+1)*(DAY($B2))

See example: http://cjoint.com/?gcl7jWXoDJ

This works only if 2 consecutive months are involved.

HTH
--
AP

"mita" a écrit dans le message de news:
...
i have got a problem..i have 3 columns in excel-startdate,end date and
volume
i need to distribute the volume amongst two months ..for ex start date os
oct 27 and end date is 7th nov, i need to distribute the volume by finding
the volume per day or prorating the days and then put some volume in oct
and
the rest in nov... how do i do that???????????

pls help