I would like to calculate rollong calendar from today in the loop.

For example, today is Dec/11/2008 and I need to get all informaiton 12
months before today. (from Dec/11/2007 to Dec/11/2008).

I just wonder can DateSerila do the job.

For example, DateSerial(MyYear, MyMonth - i, MyDay)

Will DateSerial changed the year if the month is minus number?

Your information is great appreciated,