Some elegant code
I ran into the same problems that Rodgeraj found but I came up with a different solution:
WeekStart: CDbl(YourDate)-(Weekday(YourDate)-2)
This code will work regardless of the Weekday you want to start with i.e... if you want Thursday to be the first day of your...