| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
List of start of months
I would like to be able to put a date in Cell A1 (say April 18, 2005)
Then, after recalculating, in cells B1:B24 would be: 03/01/05 02/01/05 01/01/05 12/01/04 etc - in other words, the first of the month going back 24 months. Can someone give me a formula for this? Thanks! Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| how to create a dynamic descending list of months & years | Excel Discussion (Misc queries) | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Inserting Blank Rows Macro? | Excel Worksheet Functions | |||
Threaded Mode
