Hi Jason, I thought I saw this question got answered, but now the forum is showing zero responses. Did you get an answer? Or did you figure it out? If not, post a sample workbook of what you've go so far and I'm sure you'll get an answer -- the problem doesn't sound that difficult (but then what do I know). --Shawn

Jason, I worked on this several hours last night and couldn't come up with anything workable. Sorry it's beyond my skill level. Maybe Joe or Richard will jump in. --Shawn

The way I would tackle this would be to modify the data source and add a table listing the dates of the Mondays - and define a cross product between that and your existing table.  The answer will fall out easily then.

I don't think you can do it just with table calculations off your existing data source - though as always, I'll be happy for Joe to prove me wrong.