Howard,

I'm on SQL Server 2012 so not sure if this helps or not. I've run Jeff's code through several month's and confirmed his logic is solid. Can...

Jeff,

Thanks so much for the help! That worked perfectly. I'll dig in and understand dates a little better.

Mark

I'm trying to keep everything in the specified month. In Aug 14 for example it would return only 8/1 and 8/2 (Sat) for the first week and only 8/31...