There is no workbook attached, Tim. Someone should be able to help you once it is posted, though.
Will that solution work for the 6 week averages as well? I will have a go against shortly with your suggested link.
I have attached the packaged workbook - please excuse my new'ness to the product.
1 of 1 people found this helpful
For the 6 week average I used
if [Date] <= today() and datediff('day',today(),[Date])>=-(6*7-1) then [Act_Net]/7 end