i am trying to fill a column with dates in descending order

's Computer Specifications

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

's Computer Specifications

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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting a column with numbers into descending order	=?Utf-8?B?d2FyZGxlODY=?=	Microsoft Excel Programming	2	4th Oct 2007 06:58 PM
how can i change the order(ascending, descending) in a column?	=?Utf-8?B?RGFubnk=?=	Microsoft Excel Misc	4	23rd Apr 2007 04:54 AM
Changing the auto fill order from ascending to descending	=?Utf-8?B?RGF2ZSBDLg==?=	Microsoft Excel Misc	9	26th Apr 2005 06:39 PM
How do I sort dates like Mar-05 in descending order?	Mark Allsop	Microsoft Access Queries	1	15th Mar 2005 10:25 PM
Date in descending order to come up automatically in a column?	=?Utf-8?B?U251Z2dsZWJ1bXM=?=	Microsoft Excel Worksheet Functions	2	11th Jan 2005 03:09 PM