InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 12:23:49 GMT20http://www.sqlservercentral.com/Forums/Topic740730-253-1.aspxHi,Thanks for the code. It really useful.Can you please explain the logic, so it will be easy to understand how it works. When @days are less than 0 you have done SELECT @weeks = (datepart (dw, @date) + @days - 6)/5and when @days are greater than 0then SELECT @weeks = (DATEPART (dw, @date) + @days - 2)/5how it works.Thanks & Regards,Mon, 13 Feb 2012 00:19:14 GMTJyotshttp://www.sqlservercentral.com/Forums/Topic740730-253-1.aspxWhat about holidays?Your best bet for this kind of thing is a calendar table. Lots of uses, this is one of them.Thu, 20 Aug 2009 14:20:43 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic740730-253-1.aspxThis is really great!!! Good Work!Thu, 20 Aug 2009 14:07:43 GMTSherrill Herronhttp://www.sqlservercentral.com/Forums/Topic740730-253-1.aspxThanks for this. smart programming.Tue, 23 Jun 2009 22:01:58 GMTBimal Fernandohttp://www.sqlservercentral.com/Forums/Topic740730-253-1.aspxthis is really great!! good workTue, 23 Jun 2009 21:59:33 GMTUdula Karunathilakehttp://www.sqlservercentral.com/Forums/Topic740730-253-1.aspxdeclare @date datetimedeclare @days intdeclare @weeks intselect @date = '2009-06-21'select @days = 1if (@days < 0)begin if datepart (dw, @date) = 1 select @date = dateadd (d, -1, @date) select @weeks = (datepart (dw, @date) + @days - 6)/5endelsebegin if datepart (dw, @date) = 7 select @date = dateadd (d, 1, @date) select @weeks = (datepart (dw, @date) + @days - 2)/5endselect dateadd (d, @days + (@weeks*2), @date)Tue, 23 Jun 2009 21:56:53 GMTmaluthwatta