So this is your calendar, you have one record per week, and you would like one record per date? I think this would expand your weeks out.
ref_WeekStart+iterno()-1 as Date
WHILE iterno() <= 7
I'm unclear what sort of data is in these fields, or what sort of data you want in your new Week/Month field (fields?), so I'll wait for more info on those.