Scheduled category change. How to do?

I think it is a common case:

I have three categories: Past, Current, Upcoming.

Now I write a post about next month’s event. I put this post in Upcoming category.

What I want is a scheduled category change.

i.e.:

This event runs from Dec 1 to Dec 10. From now till Nov 30, this post is in Upcoming category (I select this category when creating this post).

On Dec 1, this post will be in Current category automatically, till Dec 10.

On Dec 11, this post will be in Past category automatically.

I did a search and did not find such plug-in.

Basically, I want the publishing page to have two extra options:

Option 1: Change to Category ___ on ___

Option 2: Change to Category ___ on ___

It sounds like a workflow question. I searched workflow related plugin but still with no luck.

Any suggestion on how to implement this? I can write a plugin but I am new to WP. Could anybody suggest me which API/functions to use?

Thank you!