On Jul 15, 4:30 pm, Dan the Man
wrote:
If I want to create Date Cells in Row A (Jan 2007. Feb 2007, etc) is there a
quick and easy formula that allows me to merely copy and paste, as opposed to
typing each Date and Year in each indiviudal cell? I'm setting up dates for
2007 and 2008, and just want to find a quicker way to do it.

Does the following meet your needs?

Enter the dates 1/1/2007 and 2/1/2007 into two cells. Right-click,
click Format Cells, select Custom, and enter "mmm yyyy" in the Type
field. Now, select both cells and drag the handle in the lower right
corner across (or down) for as many dates as you need.