Hi, I need help figuring out how to create a macro that counts the number of mondays, tuesdays, etc. The tricky part is that I have a starting day of the week (ex: Tuesday) and a count of days after that (ex:2). So in this case the result should be a count of 1 for Tuesday, Wednesday, and Thursday.

The spreadsheet looks like this (part of it):
DOW LOS (Rounded)
6 1
6 1
6 1
6 1
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 2
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 3
6 4
6 4
6 4
6 4
6 4
6 4
6 5
6 5
6 5
6 5
6 5
6 5
6 5
6 5
6 5
6 6
6 6
6 6
6 6
6 6
1 7
6 7
6 7
6 8
6 10
6 10
6 12
6 12
6 13
6 13
6 13
6 19
6 21
6 22
6 27
6 42
6 55
7 1
7 1
7 1
7 1
7 2
7 2
7 2
7 2
7 2
7 2
7 2
7 2
7 2
6 3
7 3
7 3
7 3
7 3
7 3
7 3
7 3
7 3
7 3
7 3
7 3
7 3
7 3
7 3
7 3
4 4
4 4
7 4
7 4
7 4
7 4
7 4
7 4
7 4
5 5
3 5
7 5
7 5
7 5
7 5
7 5
7 6
7 6
7 7
7 7
7 7
7 8
7 10
7 10
7 10
7 10
7 11
7 11
7 11
7 13
7 13
7 13

Any help would be much appreciated!!
Melissa