Thread: dates problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mita
 
Posts: n/a
Default 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