| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to create a dynamic descending list of months & years
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 :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
| Is there a way to create a drop-down list of links in Excel? | Excel Worksheet Functions | |||
| The pivot tables 101 article says to use the "Create List" comman. | New Users to Excel | |||
| create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
| Creating a dynamic list | Excel Worksheet Functions | |||
Threaded Mode
