title: Access/Excel VBA: Getting the two dates corresponding to last week
body: <p>I think I can do this with a loop but since I am using this in conjunction with MS Access I wondered if there was a quick way to do this.</p>
  
  <p>Right now it is April 3rd, 2014. I want to be able to return the dates corresponding to the Sunday and Saturday that bookend the previous week.</p>
  
  <p>So for example that would be March 23rd (Sunday) through March 29th (Saturday) last week.</p>