LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula to increment the month by 2? thirumalairajan New Users to Excel 5 February 12th 06 12:20 AM
Excel formula to increment the month by 2? thirumalairajan Excel Worksheet Functions 2 February 10th 06 09:23 AM
Which function to use? Thuy Excel Worksheet Functions 4 January 18th 06 12:24 AM
Working days left in the month compared to previous months qwopzxnm Excel Worksheet Functions 8 October 24th 05 08:00 PM
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 06:43 PM


All times are GMT +1. The time now is 01:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"