Using Kohn-Sham density functional theory to describe charged excitations in finite systems