you mut have entered some date in dec e.g. 12/1/2005 in A1 and format it as
december-05
now highlight A1 to J1
edit-fill-series-date and check month stepvalue -1 (minus one) and clcik
ok

try this and see what you get



marika1981 wrote in message
...
I'm trying to create a spreadsheet whereby in cell A1 I enter in any given
Month and Year ("January 2005", formatted as a date), and in cells B1:J1
the
previous months and years show up (December 2004; November 2004; October
2004; etc....) If I type in "April 1985", the adjacent cells would read
"March 1985; February 1985; January 1985; December 1984; etc...

I've thought of a couple laboriuos, crude, potentially faulty ways of
doing
this, but it seems like there should be an eloquent solution.

Very much appreciated!!!
Marika :)