Search code examples
exceldateexcel-2011

Excel Place All Dates in a Range in Cells

I don't know if this is the right place to ask this, but I saw others asking Excel Questions here.

How can I get Excel to put all the Months and Years between two date ranges.

Like for example my date range is March 2004 - December 2008, so Excel should return

March 2004
April 2004
May 2004
...
November 2008
December 2008

Each cell in a column should have all the Months/Years between two dates.

Thanks

Solution

  • In Windows Excel 2010 you can just type "March 2004" into a cell and drag down as far as needed and it will increment by the month. For me it changed the format to look like "Mar-2004," but you can then format the cells with a custom format of "mmmm yyyy" to get the exact format above. To do a custom format, just right-click the cells with the dates ... oh wait, can you right-click? So, get the Format Cells dialog, choose the Number tab, then Custom at the bottom of the list, and type the format into the "Type" box near the top.

    Or did you want something more automated than this?