help with dates please
Hi Dido22
First highlight the column you want those dates, then do a custom formatting
like this mmm/yyyy.
Paste this formula in the top cell and drag down. =DATE(2010,1+ROW(A1),0)
My sample will start with Jan.2010, you just change the year and the number just
after the year for the month and copy down.
HTH
John
"dido22" wrote in message
...
Can someone please help me generate a list of dates in a column. I just need
month and year, so Jan 2010, Feb 2010, Mar 2010 .....etc. No days or dates.
Thanks KK
|