Welcome Guest
Log In | Register )
You last visited December 6, 2016, 2:46 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Help

Topic closed. 4 replies. Last post 10 years ago by lottaloot.

Page 1 of 1
PrintE-mailLink
Fibonacci's avatar - Lottery-050.jpg
New York, NY
United States
Member #39471
May 16, 2006
2696 Posts
Offline
Posted: October 17, 2006, 3:11 pm - IP Logged

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. 

$$$

    lottaloot's avatar - AvatarZ56
    Redford/MI
    United States
    Member #3396
    January 18, 2004
    4867 Posts
    Offline
    Posted: October 17, 2006, 3:34 pm - IP Logged

    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? 

    L ttaL   T

      Fibonacci's avatar - Lottery-050.jpg
      New York, NY
      United States
      Member #39471
      May 16, 2006
      2696 Posts
      Offline
      Posted: October 17, 2006, 3:36 pm - IP Logged

      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... 

      $$$

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: October 17, 2006, 3:41 pm - IP Logged

        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

        L ttaL   T

          lottaloot's avatar - AvatarZ56
          Redford/MI
          United States
          Member #3396
          January 18, 2004
          4867 Posts
          Offline
          Posted: October 17, 2006, 3:43 pm - IP Logged

          so you want it in descending order.

          L ttaL   T