THANK YOU RODGER, BREND, and RON!
i woke up this morning after thinking about it, and you were right... i was
mistakenly using 7/2/8 to 8/1/8 because i was adding to the date.

Ron, the reason i said there were 2 fridays...was because i figured the
other fridays were going to get filtered out anyway.

i was unaware that using row() would do what it did...this helps me
understand other formulas i see here.