+ Reply to Thread
Results 1 to 3 of 3

Excel date formulas

  1. #1
    Carol
    Guest

    Excel date formulas

    I need to a formula that would produce in column A a running series of dates
    without having to type them in individually. I need it such as (not
    necesarily in numerical form):

    1/03/2004
    1/04/2004
    1/05/2004
    etc....

    Thank you for any help!


  2. #2
    Paul B
    Guest

    Re: Excel date formulas

    Carol, you can put 1-3-04 in A1 and use the fill handle and drag it down,
    the little black box in the lower right hand corner, if you do need a
    formula here is one way with your starting date in A1 put this in A2 and
    drag down =A1+1

    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "Carol" <Carol@discussions.microsoft.com> wrote in message
    news:F90CC266-918A-409A-8377-012BECD364EA@microsoft.com...
    > I need to a formula that would produce in column A a running series of

    dates
    > without having to type them in individually. I need it such as (not
    > necesarily in numerical form):
    >
    > 1/03/2004
    > 1/04/2004
    > 1/05/2004
    > etc....
    >
    > Thank you for any help!
    >




  3. #3
    Carol
    Guest

    Re: Excel date formulas

    Thank you!!!!!!!!! And you know, it's sad... I remember this formula from
    the early days of Lotus now! It's just been too long ago. Thank you again.

    "Paul B" wrote:

    > Carol, you can put 1-3-04 in A1 and use the fill handle and drag it down,
    > the little black box in the lower right hand corner, if you do need a
    > formula here is one way with your starting date in A1 put this in A2 and
    > drag down =A1+1
    >
    > --
    > Paul B
    > Always backup your data before trying something new
    > Please post any response to the newsgroups so others can benefit from it
    > Feedback on answers is always appreciated!
    > Using Excel 2002 & 2003
    >
    > "Carol" <Carol@discussions.microsoft.com> wrote in message
    > news:F90CC266-918A-409A-8377-012BECD364EA@microsoft.com...
    > > I need to a formula that would produce in column A a running series of

    > dates
    > > without having to type them in individually. I need it such as (not
    > > necesarily in numerical form):
    > >
    > > 1/03/2004
    > > 1/04/2004
    > > 1/05/2004
    > > etc....
    > >
    > > Thank you for any help!
    > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1