Sorry, didn't read it close enough.
"Nick B" wrote:
Can you put the following formula in B1:
=date(year(A1),2,1)
the following in C1:
=date(year(A1),3,1)
etc. this will create a date with the year that is in A1 and the second
parameter specifies the number of the month...
"marika1981" wrote:
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 :)
|