Display the Date not Week Number

[Guest]

Basic question (I hope). I have a report that groups meetings by week -
currently the group header uses this:
=Format$([MeetingDate],"ww",0,0)
Naturally what you see on the report is the week number (like 44, 45, etc..).
What I want dsiplayed is "Week Starting 11/4/2007" "Week Starting
11/11/2007" and so on...
What do I need to do in order to accomplish this?

 

[Marshall Barton]

Basic question (I hope). I have a report that groups meetings by week -
currently the group header uses this:
=Format$([MeetingDate],"ww",0,0)
Naturally what you see on the report is the week number (like 44, 45, etc..).
What I want dsiplayed is "Week Starting 11/4/2007" "Week Starting
11/11/2007" and so on...

If your week starts on Monday, use a group header text box
expression:

=MeetingDate - DatePart("w", MeetingDate, 2) +1