Date of Monday in a given week of the year

from the Artful Common Queries page


Given a valid year value @y and a week value @w between 1 and 53, this formula gives the date of Monday in week @w of year @y:
adddate( makedate(@y,@w*7), interval 2-dayofweek(makedate(@y,7)) day )

Last updated 29 Nov 2011




Return to the Artful Common Queries page