Using Rules to Schedule Publishing/Unpublishing of Content
I've had a great experience using Scheduler to schedule publishing and unpublishing of nodes automatically.

Although this doesn't specifically answer your question because it doesnt involve rules, its worth mentioning :)