Announcement

Collapse
No announcement yet.

Creating Month-Year list in Excel

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating Month-Year list in Excel



    How do I create a column of month-year dates, e.g. Jan-09, Feb-09, ........Dec-09, Jan-10.......Dec-10?

  • #2
    Re: Creating Month-Year list in Excel

    Enter 1/1/2009 in the first cell. Format the cell per your requirements.
    In the next cell, use this formula: =EOMONTH(A1,1), drag it down as needed.
    AAE
    ----------------------------------------------------

    Forum Rules | Message to Cross Posters | How to use Tags

    Comment


    • #3
      Re: Creating Month-Year list in Excel

      Type Jan 09 in one column. Type Feb 09 in adjacent column. Select both cells, then drag the AutoFill handle horizontally until you have the number of month-year dates you require.

      Comment


      • #4


        Re: Creating Month-Year list in Excel

        Rob's solution is bit more efficient than mine, so use it if you need static dates. However, Excel will likely interpret "Jan 09" as 9-Jan (day-month), so you will need to format the cell to the desired date format.

        The one advantage of the formula approach is you can change the starting date and update all dates below.
        AAE
        ----------------------------------------------------

        Forum Rules | Message to Cross Posters | How to use Tags

        Comment

        Working...
        X