Make it Simple!
Try something like this:
A1: 01/01/2007
From the Excel main menu:
<edit<fill<series
Series in: Columns
Type: Date
Date unit: Month
Step value: 1
Stop value: 12/1/2008
Click [OK]
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"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.
Thanks
Dan
|