Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2010
    Location
    Florida
    Posts
    9
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Change the month only in a list of dates on my sread sheet

    I have a list of dates on my spreadsheet that run from Mar 01 to 31 etc. I just want to change the month in a copied new column to Apr keeping the same days.

    Is there a formula? I've tried various options & none seem to work. Suggestions appreciated.

    Regards

    Ed

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You can copy it then put 31 into a blank cell. Then you can copy the blank cell, then select the dates and paste special -values - add, to add the 31 days to make the days the next month (change the number if you want to go from a month with less days)

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    edh001 (2011-03-24)

  4. #3
    New Lounger
    Join Date
    Jan 2010
    Location
    Florida
    Posts
    9
    Thanks
    3
    Thanked 0 Times in 0 Posts
    worked like a charm. Thank you.

  5. #4
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,199
    Thanks
    48
    Thanked 987 Times in 917 Posts
    Only works when there are 31 days in the month, obviously.

    cheers, Paul

  6. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Only works when there are 31 days in the month, obviously.
    WHich was why I indicated: "(change the number if you want to go from a month with less days)"...

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •