Wasn't even thinking of a table driven way of date evaluation. I like it though, must of took some time to write that.

FYI: By adjusting the CTE to a...

Great way to do date advancement: http://codemiller.blogspot.com/2010/07/sql-server-2005-date-advancement.html

Check this out... very nice: http://codemiller.blogspot.com/2010/07/sql-server-2005-date-advancement.html - skips weekends and could be easily retrofitted for calendar lookups.

Can you elaborate on this? I don't understand what you did.