Honestly, the punishment of two weeks of abstinence was not difficult for Andrew, since he had gone much longer than that without sex in his previous life, but now everything was different.
As a candidate for god Eros, his libido was much stronger than anyone else's and two weeks was torture, especially since his wives were going to torture him even more.
If he were to just abstain, he could get over it, but you have to understand, that his wives wouldn't leave him with such a simple punishment. They would still sleep in the same bed as him every night.
They would lay their scantily clad sensual bodies against him when they slept and that was the real punishment. In short, they would tempt him every night and he couldn't do anything.
While he could coax them with sweet words and loving caresses, this would only make things worse. His wives were cruel, they would not refuse his attempts of seduction, but the next day they would impose a worse punishment.