3 Ways to Compare the Same Weekday Across Weeks in Excel
📝 Download the sample Excel file here and follow along: https://www.marg-analytics.com/post/c...
There’s more than one way to solve the same problem in Excel.
From fixed → dynamic → flexible
Each approach can work well depending on the workflow.
The key is choosing the one that fits your use case.
⏱️Video Chapter
00:00 Introduction
00:33 Method 1 - Hardcoded Weekday
02:17 Method 2 - Dynamic Weeks
04:39 Method 3 - Selected Weekday
06:55 Explanation