- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- 永久链接
- Email to a Friend
- Report Inappropriate Content
04-22-202103:25 AM
04-22-202103:25 AM
The trick her is to manipulate the value for the days so that you replace the weekend value with the first two values of the moving 5 day average.
Therefore, as the moving average progresses the function includes the weekends but the values for Tues and Weds are posted forward into Sat and Sun so they are included in the movingsum.
Create a new line which I have called, 'Movingsum Value', and using WEEKDAYS to distinguish which day of the week post forward 4 days if the weekday is 6 or 7. This has the effect of replacing Sat and Sun with the values from Tue and Wed.
You can then use the MOVINGSUM function as standard to calculate a moving average.
Chris
HeathcoteAndHerran.com
HeathcoteAndHerran.com