Distribute values within a date range
- by JOT
I really need some help with Excel. I have a specific data that contains tasks, amount per tasks with start and end dates respectively.
Would like to distribute the data within a range data to quantify how much per month:
I have been using the Sumproduct function
=SUMPRODUCT(I$3:I$60,--(J$3:J$60>=$A2),--(K$3:K$60<=$B2))
where,
I$3:I$60 is the Load or value to add;
J$3:J$60 is the specific start date;
K$3:K$60 is the specific end date;
And the range to distribute the data is between
A2(as the start date range) and B2(as the end date range).
I am unable to get the distribution for specific end dates that exceed the range distribution (or K>B) returning 0 as result.
