I think what you're saying OP is that you want to be able to drink Friday/Saturday, but then stop for the rest of the week. But this isn't working for you because if you drink on Saturday, say, you want to drink on Sunday anyway, so you do, and then it becomes Monday, Tuesday...etc.
I think what you're describing is a completely normal and common experience. Alcohol makes your brain think you need it, so you drink it, but then the next day, you feel rubbish, and your brain knows that you can drink more of it and feel less rubbish for a bit...and on and on. There's only two ways out of this.
One is that you rely purely on distraction and willpower and you don't drink on days you don't want to drink on. You do something else with your time. You have a cup of tea or an AF beer instead of a drink, even if you're out for Sunday lunch or it's a friend's birthday or whatever. Some people can do that and it's no big deal. Some people can't. If you are someone who can't, your only option if you want to get out of this cycle is to stop drinking, full stop.
You need to work out what sort of person you are. I certainly know people who have always gone out for a nice lunch and just had a fizzy water because they don't drink much alcohol or they had a heavy night the night before and don't want it. If you're not that kind of person, you can't wish yourself into being one, fortunately/unfortunately.
It may not sound like it, but it's so much easier to just not drink than to drink sometimes and not others, if you are always someone who'd opt to drink rather than not. I gave up drinking 6 months ago. I was like you, if I drank the day before, I'd always find an excuse to drink again that day, and on and on, until I was drinking heavily every day. Now that I'm sober, I honestly don't want a drink. It's not a big deal to have a fizzy water at Sunday lunch. Because I've stepped out of that cycle.
And from a parenting perspective, parenting without drinking is so much easier. I hadn't realise how bloody hard I was making it all for myself all these years. The life I was drinking to escape from is not nearly as hard now that I'm not drinking. I was making it so hard for myself. Now I cope much better and have more energy and sleep more, all those things that we need as parents.