Two weeks. They started the replacement Friday and it should be completed this week - or so they think. FYI, the transmission didn't fail, it just wouldn't upshift from 1-2 when at WOT. Otherwise, it drove completely fine without any issues, no CEL. I was shocked when they said the transmission was being replaced as I didn't think it was a transmission issue and more of some type of PCM Engine/Transmission communication issue.
There's another member on this forum
@White RHO that literally went through the same issue, had his transmission replaced, and it didn't resolve anything. He's currently waiting without resolution.
@White RHO, feel free to chime in if I'm off the mark.