I have a bunch of workbooks that contain the following information.

Cell A1: 1/2/05 to 1/8/05

I want to be able to copy this to Cell A2 looking like 1/9/05 to 1/15/05.

When I do it know it says 1/2/05 to 1/9/05 only changing the seconds date's
day.

Is it possible?

One way:

=TEXT(LEFT(A1,FIND(" to",A1)-1)+7,"m/d/yy to ") &
TEXT(MID(A1,FIND("to",A1)+3,255)+7,"m/d/yy")


In article ,
cwwolfdog wrote:

I have a bunch of workbooks that contain the following information.

Cell A1: 1/2/05 to 1/8/05

I want to be able to copy this to Cell A2 looking like 1/9/05 to 1/15/05.

When I do it know it says 1/2/05 to 1/9/05 only changing the seconds date's
day.

Is it possible?

You may save yourself a lot of hassle by entering the date span in 2 cells,
1/2/05 in A1, 1/8/2005 in B1. Format A1 as m/d/yy, B1 as "to "m/d/yy

Then you can use the formulas =A1+7 and =B1+7 in row 2 and ocpy down. Or enter
the dates in the 2nd row, then use the Fill Handle.



On Sun, 20 Feb 2005 05:15:06 -0800, cwwolfdog
wrote:

I have a bunch of workbooks that contain the following information.

Cell A1: 1/2/05 to 1/8/05

I want to be able to copy this to Cell A2 looking like 1/9/05 to 1/15/05.

When I do it know it says 1/2/05 to 1/9/05 only changing the seconds date's
day.

Is it possible?