Excel Help

Reply #4

lottaloot — Tue, 17 Oct 2006 19:43:48 GMT

so you want it in descending order.

Reply #3

lottaloot — Tue, 17 Oct 2006 19:41:05 GMT

If so, I simply labeled A1 date

in A3 I place the date that I want to start with

in A2 I place the formula =A3+1--this way when I insert a new column it automatically goes to the date below it +1

Reply #2

Fibonacci — Tue, 17 Oct 2006 19:36:53 GMT

fIGURED IT OUT..

iN CAse anyone else has similar problem:

1. Enter first two items in the series

2. Drag the fill handle (the corner-lower right or upper left as case may be) all the way top where you want the last item in the series to be

Voila...

Reply #1

lottaloot — Tue, 17 Oct 2006 19:34:24 GMT

Let's clarify, shall we?

When you say generate dates, are you expecting the most recent date to appear on top as you have it above

Excel Help

Fibonacci — Tue, 17 Oct 2006 19:11:02 GMT

I'd appreciate help from anyone on a little Excel problem.

Basically, I would like to create an auto list of dates as follows:

12/31/2004 (example)

....and automatically genarate up to x number of dates before that date...

so the list will look

12/31/2004

12/30/2004

12/29/2004

....

etc

is there an auto way top do that...I suspect it's right at my fingertips but I cannot see it.