an idea to get you started
SELECT COUNT(MRN) AS visits,
DATEPART(MONTH, ApptDt2) AS monthno,
DATEADD(day, 6 - DATEDIFF(day, 6, ApptDt2) % 7, ApptDt2) AS WE
FROM Visits
GROUP BY
DATEPART(MONTH, ApptDt2),
DATEADD(day, 6 - DATEDIFF(day, 6, ApptDt2) % 7, ApptDt2)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day