@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 2024
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 2024 |
|