Display the Date not Week Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Peter said:
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...
Click to expand...


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

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