| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
i am trying to fill a column with dates in descending order
i am trying to fill a column with dates in descending order from dec. 31,2010
to jan.1 2010 and i having a difficult time trying to accomplish this |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
i am trying to fill a column with dates in descending order
zanc1one,
First format the column the way that you want it (i.e. Date ,Type: "14-Mar-01") In the first cell say A2 put "31-Dec-10". In the cell below it (A3) put "=A2 - 1" It will change to 30-Dec-10 Then just copy cell A3 down until you get to "1-Jaan-10" hth "zanc1one" wrote: i am trying to fill a column with dates in descending order from dec. 31,2010 to jan.1 2010 and i having a difficult time trying to accomplish this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to order chart in descending order of Freq? | Charts and Charting in Excel | |||
| Top 10 in descending order | Excel Worksheet Functions | |||
| how can i change the order(ascending, descending) in a column? | Excel Discussion (Misc queries) | |||
| Changing the auto fill order from ascending to descending | Excel Discussion (Misc queries) | |||
| Date in descending order to come up automatically in a column? | Excel Worksheet Functions | |||
Linear Mode
