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?