How to I get a date to go from 1/2/05 to 1/8/05 -> 1/9/05 to 1/15.

C

cwwolfdog

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?
 
J

JE McGimpsey

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")
 
M

Myrna Larson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I write a formula in excel where 1 = .05 and 2 = .75 etc. 2
Finding dates without attention to data formats 3
Help on multiple criteria for formula and return a date 1
IF ARRAY with multiple conditions. 1
Modifying a complex date formual to count months 4
Formula to copy related information from sheet 1 to sheet 2 0
Multiple variables to sort and sum, return values<0 with sum refer 5
help with datedif function please 5

Top