Thanks for the quick response Jeff.  This works perfectly for Sun-Thurs.  Fri and Sat return the previous week (ie if I run it tomorrow, the end date is still 8/2). ...