How do you change the year but not the month automatically?

[Autumn Dreams]

One of the columns in my spreadsheet is:

Jan-06
Feb-06
March-06 (Etc)

Is there any way to change the year for Jan- 06 (say to Jan- 07) and it will
automatically change the rest of the months year to 07?

Thank you.

[Dave Peterson]

=date(year(a1),month(a1)+1,1)

Format the way you want. And drag across.

Autumn Dreams wrote:
>
> One of the columns in my spreadsheet is:
>
> Jan-06
> Feb-06
> March-06 (Etc)
>
> Is there any way to change the year for Jan- 06 (say to Jan- 07) and it will
> automatically change the rest of the months year to 07?
>
> Thank you.

--

Dave Peterson