Home Forums SQL Server 2005 T-SQL (SS2K5) How to find the 2nd Monday following a given date. RE: How to find the 2nd Monday following a given date.

  • To make sure first day of the week is Monday so you can assume that, to get the next Monday, just add 8 minus the current day of the week. Monday after next can be calculated by adding 15 minus current day of the week.

    Here's the full description from BOL.