Horgan announced he was on leave in June after being diagnosed with thyroid cancer