+ Reply to Thread
Results 1 to 5 of 5

How to get list of months for specific number of years?

  1. #1
    Registered User
    Join Date
    04-16-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    Lightbulb How to get list of months for specific number of years?

    How do I get continued list of months for specific number of year?

    e.g. if I entered 5 years, starts from January 2014 then below list will come which have January 2014 to December 2014 then again January 2015 to December 2015...till December 2019.

    How can I get this any one have idea?
    Last edited by milindbharambe; 04-24-2014 at 01:50 AM.

  2. #2
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: How to get list of months for specific number of years?

    like this?
    Years.xlsx
    Click on the star if you think I helped you

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,370

    Re: How to get list of months for specific number of years?

    Hi,

    You can only automate that with a macro. But why not just enter 1/1/2014 in A1 and in A2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then copy A2 down to A60
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    04-16-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: How to get list of months for specific number of years?

    thanks adyteo...This is what I wanted exactly.

  5. #5
    Registered User
    Join Date
    04-16-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: How to get list of months for specific number of years?

    thanks adyteo...This is what I wanted exactly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Summing Values for specific months and years
    By Catflappo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-30-2014, 05:57 PM
  2. Replies: 8
    Last Post: 02-20-2014, 05:46 PM
  3. [SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2013, 04:20 PM
  4. Replies: 9
    Last Post: 01-22-2009, 06:01 PM
  5. how do I convert a number to number of years, months and days
    By because in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2005, 02:05 PM

Tags for this Thread

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