find totals for a month

[supper's ready]

start date end date forecast sales per day
1/1/2011 1/5/2011 2500
1/2/2011 3/20/2011 4000
1/5/2011 2/3/2011 5000

I need to know the sum of the forecast for jan

not sure how to do this

 

[c_m_s_jr]

What would the expected result be?

 

[yogeshmaney]

has it been distributed on prorate basis between Start date and end date

 

[supper's ready]

the total for jan should be:
start date end date forecast sales per day
1/1/2011 1/5/2011 2500
1/2/2011 3/20/2011 4000
1/5/2011 2/3/2011 5000

10000 =2500* 4
116000 = 4000* 29
130000 = 5000* 26
=256000

 

[c_m_s_jr]

How did you determine the 4, 18, 26?

 

[supper's ready]

there are 4 days between 1/1/2011-1/5/2011
etc.

i want to make totals for each month jan-dec but my date ranges span multiple months.