Drink is rarely the problem itself, but is a symptom more often than not of other problems.
Quite often that problem simply is a lack of anything better to do. During the week you have your work, your gym and more.
The weekend however is a hole. Idle hands and all that.
You very likely will therefore keep failing if you say to yourself “I will not do it again this weekend” and you have nothing else at the weekend to look forward to. You can not just switch off something that has been a part of your life and expect the void to fill itself.
Each and every time you will be driving home from work and nothing much to look forward to for the weekend, so Drink will simply rush back into the void.
Instead of concentrating on stopping therefore, try instead to approach it by filling your weekend with something else. It does not even have to be something that is totally devoid of alcohol either… just something that severely curtails it. Something you do with other people for the day, but then hit the beer after it for example.
What that something(s) is/are can be any number of things. Have a look around and get involved in some things at the weekend. With the summer coming up there will likely be a lot more outdoor pursuits too.
However I fully expect you to keep failing if you simply try and stop drinking, and then sit there twiddling your thumbs with nothing else to do to replace it.