Thread: how do i do this - increment month by 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default how do i do this - increment month by 1
i have 12 worksheets, 1 for each month

column a has dates
03/10/06
03/10/06
03/10/06
03/10/06
03/10/06
03/14/06
03/14/06
03/17/06
03/15/06
03/20/06
03/20/06
03/21/06
03/21/06
03/23/06
etc for march

i copy march ss to month 4, april

how do i pop the month up by one instead of going though each cell and
change the 03 to 04

day and year remain the same

tia
Reply With QuoteReply With Quote