I have trying to create a formula so that I do not have to drag across
columns to change months.

Example: July 05, Aug 05, Sept 05, etc. (each month in its own column)

I want to change July 05 to another month and have the rest of the months
change. I normally would change July 05 to Aug 05 and need each additional
month to increase by one month. I am using Excel 2000.

Is this possible? Any help??