I already have some SQL which shows me the # of transaction per hour, per day at a store in a given week. I have increased my date range to 2 weeks for this example.
Week 1 Monday - 12pm-1pm - total # transactions = 10
Week 2 Monday - 12pm-1pm - total # transactions = 12
So now that i have increased my date range the total is showing as 22.
What i would like to do is determine how many times a Monday occurs within the date range so i can then average out the number of transactions. In this example i know it is 2 but it wont always be that simple.
How do i work out how many times a Monday occurs within a certain date range?