Thread: How do you change the year but not the month automatically?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do you change the year but not the month automatically?
=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
Reply With QuoteReply With Quote