+ Reply to Thread
Results 1 to 8 of 8

Date Fill

  1. #1
    Forum Contributor
    Join Date
    02-16-2006
    Posts
    200

    Date Fill

    I would like to create a spreadsheet where if you input date as Jan06 in cell
    A1, subsequent cells B1 C1 D1 etc automatically fill as feb06,mar06,apr06 -

    Can anyone help

  2. #2
    Niek Otten
    Guest

    Re: Date Fill

    In B1:

    =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

    Fill right

    --
    Kind regards,

    Niek Otten
    Microsoft MVP - Excel

    "martins" <martins.2c26p2_1154767506.805@excelforum-nospam.com> wrote in message
    news:martins.2c26p2_1154767506.805@excelforum-nospam.com...
    |
    | I would like to create a spreadsheet where if you input date as Jan06 in
    | cell
    | A1, subsequent cells B1 C1 D1 etc automatically fill as
    | feb06,mar06,apr06 -
    |
    | Can anyone help
    |
    |
    | --
    | martins
    | ------------------------------------------------------------------------
    | martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
    | View this thread: http://www.excelforum.com/showthread...hreadid=568582
    |



  3. #3
    Leo Heuser
    Guest

    Re: Date Fill

    "martins" <martins.2c26p2_1154767506.805@excelforum-nospam.com> skrev i en
    meddelelse news:martins.2c26p2_1154767506.805@excelforum-nospam.com...
    >
    > I would like to create a spreadsheet where if you input date as Jan06 in
    > cell
    > A1, subsequent cells B1 C1 D1 etc automatically fill as
    > feb06,mar06,apr06 -
    >
    > Can anyone help
    >
    >
    > --
    > martins


    Hi Martins

    One way:

    1. Select A1:D1
    2. Format the cells with the custom format mmmyy
    3. In A1 enter 1/1/06
    4. In B1 enter the formula
    =DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))
    5. Copy B1 to C1:D1 with the fill handle
    (The little square in the lower right corner of the cell).

    --
    Best regards
    Leo Heuser

    Followup to newsgroup only please.



  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))


    VBA Noob

  5. #5
    Registered User
    Join Date
    08-05-2006
    Posts
    1

    Fill Date Formula

    Quote Originally Posted by Leo Heuser
    "martins" <martins.2c26p2_1154767506.805@excelforum-nospam.com> skrev i en
    meddelelse news:martins.2c26p2_1154767506.805@excelforum-nospam.com...
    >
    > I would like to create a spreadsheet where if you input date as Jan06 in
    > cell
    > A1, subsequent cells B1 C1 D1 etc automatically fill as
    > feb06,mar06,apr06 -
    >
    > Can anyone help
    >
    >
    > --
    > martins


    Hi Martins

    One way:

    1. Select A1:D1
    2. Format the cells with the custom format mmmyy
    3. In A1 enter 1/1/06
    4. In B1 enter the formula
    =DATE(YEAR(A1), MONTH(A1)+1, DAY(A1))
    5. Copy B1 to C1:D1 with the fill handle
    (The little square in the lower right corner of the cell).

    --
    Best regards
    Leo Heuser

    Followup to newsgroup only please.
    Thank you Leo Heuser ... you gave a much clearer solution.

    Regards,
    Syed

  6. #6
    Leo Heuser
    Guest

    Re: Date Fill

    "Syed Haneef" <Syed.Haneef.2c28jq_1154769906.3495@excelforum-nospam.com>
    skrev i en meddelelse
    news:Syed.Haneef.2c28jq_1154769906.3495@excelforum-nospam.com...
    >

    Thank you Leo Heuser ... you gave a much clearer solution.
    >
    > Regards,
    > Syed
    >
    >


    You're welcome, Syed, and thanks for the feedback :-)

    Regards
    Leo Heuser



  7. #7
    Forum Contributor
    Join Date
    02-16-2006
    Posts
    200
    Works fine Leo - thank you very much for help and all other that replied

    martins

  8. #8
    Leo Heuser
    Guest

    Re: Date Fill

    "martins" <martins.2c3a1v_1154818510.8852@excelforum-nospam.com> skrev i en
    meddelelse news:martins.2c3a1v_1154818510.8852@excelforum-nospam.com...
    >
    > Works fine Leo - thank you very much for help and all other that
    > replied
    >
    > martins
    >


    You're welcome, Martins, and thank you for the feedback.

    Leo Heuser



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1