dates problem
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
|