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 |
#2
|
|||
|
|||
One way
in B1 put =DATE(YEAR(A1),MONTH(A1)-1,1) in B2 =DATE(YEAR(B1),MONTH(B1)-1,1) copy down or in B1 =DATE(YEAR($A$1),MONTH($A$1)-ROW(B1),1) copy down Regards, Peo Sjoblom "Daniel Bonallack" wrote: 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 |
#3
|
|||
|
|||
Thank you very much!
Daniel "Peo Sjoblom" wrote: One way in B1 put =DATE(YEAR(A1),MONTH(A1)-1,1) in B2 =DATE(YEAR(B1),MONTH(B1)-1,1) copy down or in B1 =DATE(YEAR($A$1),MONTH($A$1)-ROW(B1),1) copy down Regards, Peo Sjoblom "Daniel Bonallack" wrote: 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 |
Reply |
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 |