in reply to Calculating latest 'Sunday' date on the first of the month

You might want to check out Is there an easy way to get the start date of the current week?. Although it's not exactly what you're trying to do, it may be close enough that the suggestions in that thread might be able to help you out.

  • Comment on Re: Calculating latest 'Sunday' date on the first of the month