i checked your results, and if you look at the 1st set of values for X May 21-May 27, the total is 450 (100+150+200). your total comes up to 100?

oh wait, i see where the difference comes in. your formula mathes the dates, mine adds the dates for the week from may21 to may 72