WEEKOFYEAR(<date>)
Returns the week of the year for the supplied date in a range from 1 to 53.
Jan 1, 2018 12:23:05
Jun 14, 2018 12:23:05
Dec 25, 2018 12:23:05