I am trying to calculate the number of Mondays, Tuesdays, Wednesdays, etc in any given month. Example...in September 2008 there are 5 Mondays. 4 Fridays, etc. Does anyone know a SQL statement that does this.