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