Can my car kill a battery in 2 weeks?

Not in this case but similar- when doing the battery/test light test- rather than testing to the cable, test to the battery itself. In the old days found many batteries discharging 4-6v just because they were dirty.