Is it possible to add date sequence each time I run a macro?

Suppose I have a date table contains date 20/05/08 and dateID 1, I need to run macro to insert dateID as 2 and date as 21/05/08, I need this because I will run more macros in that specific macro...

Any advice will be appriciated.... Thanks in advance....

Arif