Hi,

Need help creating a formula that pick's up the moving average for a number within 6 business days.

Example) The amount for a line item over the past Weekdays were 1, 4, 6, 8, 9. I want to forecast this by finding the average of those days.

Thank you