Thread: Make it Simple!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meebers Meebers is offline
external usenet poster
 
Posts: 80
Default Make it Simple!

I usually put Jan 2007 in column A Feb 2007 in column B select both cells,
grab the handle and drag to the right. Works for up and down also.

"Dan the Man" wrote in message
...
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.

Thanks

Dan