Thank you for your help. I in fact do have a calendar table setup with code from: http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

It comes in very handy.

I will see if I can apply it to this solution.

btw- did I use improper etiquette for my code post? I saw the link in your signature and thought I followed the standards; but maybe I missed something?