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?

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?