I am with ST on this except, I would say your H is already attracted. If you love to dance, go dance.
As for how long? First, I would say you are lucky that it hasn't been a quick fix. That would be a recipe for disaster. I was out of the house for a month once and nothing changed. That led to the eventual big bomb and subsequent divorce. The big thing you have going is that your H recognizes he has issues.
Don't worry about time. I would say worry about the feelings you have. And right now, the feeling is that you want your H to get his head together and come home.
Let me tell you about time. My grandfather died in 1950 a few years before I was born. My grandmother lived another 45 years...on her own (and with my aunt and uncle and their family). In essence, she stood for her marriage the rest of her life. Yes, a long time. But she was perfectly happy. I have been divorced for 6 1/2 years. Still on my own with no change in sight. It has been great. Accept the good that you have and you will be happy no matter what happens.