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 Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA