Results 1 to 6 of 6

Thread: Required auto fill of months using month number
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2017
    Location
    INDIA
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Required auto fill of months using month number

    HI every one,

    i need a small logic if any one can help it will be very great full to me.

    Month 8
    Year 2019
    Calander Year 08.2019 09.2019 10.2019 11.2019 12.2019 01.2020 02.2020 03.2020 04.2020 05.2020 06.2020 07.2020 08.2020 09.2020 10.2020 11.2020 12.2020 01.2021 02.2021 03.2021 04.2021 05.2021 06.2021


    Highlighted values to populated based on Month & Year Selection from Drop Down

    Thanks in advance


    Thanks & Regards,
    Raviteja

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,886
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Required auto fill of months using month number

    Assuming your first date is in place place the formula in C3 and drag across

    Excel 2013/2016
    ABC
    1Month8
    2Year2019
    3Calander Year8.20199.2019

    Sheet1



    Worksheet Formulas
    CellFormula
    C3=EDATE(B3, 1)

    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    New Member
    Join Date
    Dec 2017
    Location
    INDIA
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Required auto fill of months using month number

    Quote Originally Posted by Michael M View Post
    Assuming your first date is in place place the formula in C3 and drag across

    Excel 2013/2016
    A B C
    1 Month 8
    2 Year 2019
    3 Calander Year 8.2019 9.2019
    Sheet1

    Worksheet Formulas
    Cell Formula
    C3 =EDATE(B3, 1)

    sorry michael the logic which you have suggested not worked

  4. #4
    Board Regular
    Join Date
    Dec 2008
    Posts
    6,742
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Required auto fill of months using month number

    Try this in B3
    =EDATE(DATE($B$2,$B$1,1),COLUMNS($B3:B3)-1)

  5. #5
    New Member
    Join Date
    Dec 2017
    Location
    INDIA
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Required auto fill of months using month number

    hi jason & michael,

    i have got the following logic to complete the task.

    thanks for you efforts

    Month
    8
    Year 2019
    Calander Year =date(b2,b1,1) =edate(b3,1)


    thanks
    Raviteja

  6. #6
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,886
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Required auto fill of months using month number

    Glad WE could help....thx for the feedback..
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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