Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Selecting cell range and increasing month (2000)

    I am trying to work out how to select a cell range and so that when l select the range and drag it , and will increase the date by month and not by year.
    When l try this it does not work as it uses the same month but a different year (see atatchment).
    I would like it to appear as

    Project Control Reports Oct' 03
    Project Control Reports Nov '03
    Project Control Reports Dec'03


    Any assistance would be appreciated.

    Justin.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Selecting cell range and increasing month (2000)

    You could do the following:
    In a cell, enter a date as Jul-2003
    In the cell next to it, enter the formula
    <code>="Project Control Report - "&TEXT(A1,"mmm 'yy")</code>
    where A1 must be replaced with the cell containing the date.
    Select the two cells.
    Drag the fill handle down as far as needed.
    You can now hide the column with the dates, if you like.
    See attached workbook.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selecting cell range and increasing month (200

    That's great thanks.

    Justin

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Selecting cell range and increasing month (2000)

    You could have "Project Control Reports - " in one column (A1) and a valid date "Oct 03" in another column (B1), and then join them with =A1&B1 formula. Fill down the date with autofill (rightclick) and select Fill Months.

    Edited: Reworked formula after reading Hans reply - =A1&Text(B1, "mmm-yy"). Tx Hans! (I forgot that a date returns to its raw "number" state when converted to text! <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Regards,
    Rudi

Posting Permissions

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