+ Reply to Thread
Results 1 to 3 of 3

auto dating after entering the first date

Hybrid View

  1. #1
    Jomo Watts
    Guest

    auto dating after entering the first date

    I have a Timesheet that has a row of dates for a two week period, I would
    like to enter the first date and have the rest of the remaining days auto
    compute the correct date. I used to have a Timesheet that had a formula for
    this but I'am no longer able to find it.

    Thanks

  2. #2
    Fred
    Guest

    Re: auto dating after entering the first date


    Jomo Watts wrote:
    > I have a Timesheet that has a row of dates for a two week period, I

    would
    > like to enter the first date and have the rest of the remaining days

    auto
    > compute the correct date. I used to have a Timesheet that had a

    formula for
    > this but I'am no longer able to find it.
    >
    > Thanks


    If your date appears in cell A1, for instance, then cell A2 could
    contain the formula =A1+1; cell A3 could contain =A2+1..... Just copy
    down as many rows to complete your two week period.


  3. #3
    Jomo Watts
    Guest

    Re: auto dating after entering the first date

    Thanks Fred it worked perfect!

    "Fred" wrote:

    >
    > Jomo Watts wrote:
    > > I have a Timesheet that has a row of dates for a two week period, I

    > would
    > > like to enter the first date and have the rest of the remaining days

    > auto
    > > compute the correct date. I used to have a Timesheet that had a

    > formula for
    > > this but I'am no longer able to find it.
    > >
    > > Thanks

    >
    > If your date appears in cell A1, for instance, then cell A2 could
    > contain the formula =A1+1; cell A3 could contain =A2+1..... Just copy
    > down as many rows to complete your two week period.
    >
    >


+ 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