+ Reply to Thread
Results 1 to 2 of 2

auto posting dates

  1. #1
    maintchief
    Guest

    auto posting dates

    Excel 97. I am printing labels for time cards. One side of the TC is for week
    1 and the other for week 2. Each label shows the week start date and week
    end date (w1 -'10/23/05-10/30/05', w2 -'10/31/05-11/05/05'). Right now I key
    in the two date ranges on an info sheet to be inserted into the appropriate
    cells in the label sheets. I am trying to enter only one date and have the
    other three calculated, then inserted in the appropriate cells on the label
    pages (enter 10/23/05 and have the other three dates auto calculated, then
    insert 10/23/05-10/30/05 on side one label and 10/31/05-11/05/05 on the side
    two label. I can do the auto calculations with one date in a cell (4 cells),
    but I can't seem to combine the two needed dates into one cell for the label.
    Can this be done?

  2. #2
    bpeltzer
    Guest

    RE: auto posting dates

    If your start date is in B3 then
    =TEXT(B3,"mm/d/yy") & " - " & TEXT(B3+6,"mm/d/yy")
    will get you the first TC date range. Replace B3 and B3+6 with B3+7 and
    B3+13, respectively, to get the second range.
    --Bruce

    "maintchief" wrote:

    > Excel 97. I am printing labels for time cards. One side of the TC is for week
    > 1 and the other for week 2. Each label shows the week start date and week
    > end date (w1 -'10/23/05-10/30/05', w2 -'10/31/05-11/05/05'). Right now I key
    > in the two date ranges on an info sheet to be inserted into the appropriate
    > cells in the label sheets. I am trying to enter only one date and have the
    > other three calculated, then inserted in the appropriate cells on the label
    > pages (enter 10/23/05 and have the other three dates auto calculated, then
    > insert 10/23/05-10/30/05 on side one label and 10/31/05-11/05/05 on the side
    > two label. I can do the auto calculations with one date in a cell (4 cells),
    > but I can't seem to combine the two needed dates into one cell for the label.
    > Can this be done?


+ 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