+ Reply to Thread
Results 1 to 4 of 4

dates - automatically fill next day

  1. #1
    Registered User
    Join Date
    10-05-2005
    Posts
    6

    dates - automatically fill next day

    Hi there - I am a new user, have only started using excel 2 days ago but am really enjoying it. I have managed to create timesheets that automatically calculate the time spent on a project. Anyway, enjoying it very much.

    So, I have dates running down the left hand column (A), eg, 05.10.05. Currently I am inputting these by hand because if I drag that cell down it creates 05.10.06, 05.10.07 etc. I have messed with the 'custom' setting and changed it to 'dd.mm.yy' but this has not solved it.

    Any help much appreciated.

    By the way, it's excel 2001 for mac.

    Tom

  2. #2
    Bernard Liengme
    Guest

    Re: dates - automatically fill next day

    Could you live with the data in format dd/mm/yy ?
    Then dragging the cell increments the date by 1
    Have you tried putting a date in A1 and in A2 enter =A1+1 ?
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "small tom" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hi there - I am a new user, have only started using excel 2 days ago but
    > am really enjoying it. I have managed to create timesheets that
    > automatically calculate the time spent on a project. Anyway, enjoying
    > it very much.
    >
    > So, I have dates running down the left hand column (A), eg, 05.10.05.
    > Currently I am inputting these by hand because if I drag that cell down
    > it creates 05.10.06, 05.10.07 etc. I have messed with the 'custom'
    > setting and changed it to 'dd.mm.yy' but this has not solved it.
    >
    > Any help much appreciated.
    >
    > By the way, it's excel 2001 for mac.
    >
    > Tom
    >
    >
    > --
    > small tom
    > ------------------------------------------------------------------------
    > small tom's Profile:
    > http://www.excelforum.com/member.php...o&userid=27828
    > View this thread: http://www.excelforum.com/showthread...hreadid=473342
    >




  3. #3
    Registered User
    Join Date
    10-05-2005
    Posts
    6
    Thanks - think I just sorted it by starting at the point you gave me. This still didn't quite work as it changed it to mm/dd automatically but I went in and swapped it to 14-march-05 and now it will autofill when dragging it. Thanks for the point in the right direction - am sure I will be bothering you again.

    Tom

  4. #4
    Bernard Liengme
    Guest

    Re: dates - automatically fill next day

    Here to help but I'm off on vacation for a few weeks
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "small tom" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Thanks - think I just sorted it by starting at the point you gave me.
    > This still didn't quite work as it changed it to mm/dd automatically
    > but I went in and swapped it to 14-march-05 and now it will autofill
    > when dragging it. Thanks for the point in the right direction - am sure
    > I will be bothering you again.
    >
    > Tom
    >
    >
    > --
    > small tom
    > ------------------------------------------------------------------------
    > small tom's Profile:
    > http://www.excelforum.com/member.php...o&userid=27828
    > View this thread: http://www.excelforum.com/showthread...hreadid=473342
    >




+ 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