I spent days trying to figure this out....right after I posted this question I figured it out!
There's an option named "show missing values" in the "WEEKDAY(Month-Ye" pill in the columns. When I click "show missing values" it now shows Friday for 2017. Now when the formula compares the last 7 days it calculates the percentage difference for the correct weekday.
Thank you for reading anyways!