Exclude Sundays from Rolling x number of days

I’m working on a cost analysis for certain products and how our cost to purchase is trending over a rolling 45 day period. We are not open on Sundays, so once in every 7 day period by trend goes to 0. Is there way to create custom rolling period that will ignore Sundays?

image

1 Like