One way
With A1 containing, say: January 2005
Put in B1:
=DATE(YEAR($A1),MONTH($A1)-COLUMNS($A$1:A1),1)
Format as per date in A1
Copy B1 across as many cols as needed
The above will return what is wanted
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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 :)
|