Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    increment month (97 sr2)

    I want user to enter one date only, and from this date the next 11 cells are updated to incremented months/year.
    i.e. user enters 01/05/2003 in cell C4 and cells C5 to C16 are automatically updated with 01/06/2003 to 01/04/2004.

    Currently I am using this concatenation formula (this is in C5):
    =IF(MONTH(C4)<9,"01/0","01/")&IF(MONTH(C4)=12,"01",MONTH(C4)+1)&"/" & IF(MONTH(C4)=12,YEAR(C4)+1,YEAR(C4))
    and then this formula in D5:
    =C5+MONTH(N(C5))
    The cells in column D incidentally are formatted for MMM-yy
    Is there a simpler way or am I just imagining it.
    TIA
    Alan,
    Cheshire

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: increment month (97 sr2)

    You could try this in C5. You can copy this formula for the rest of the dates.
    =DATE(YEAR(C4),MONTH(C4)+1,1)

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: increment month (97 sr2)

    Thanks Tony,
    I knew it was there somewhere.
    Alan

Posting Permissions

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