Dates in a text string?

S

seve

Hello,

I need to have column headings in this format m/dd - m/dd, the range
would be one week.

The next column would be the next week's date range.

Is there an easy way to do this without typing these by hand?

Example:

Column A= 5/13 - 5/19
Column B = 5/20 - 5/26

Any help would be appreciated.

FYI - I tried using concatenate...but I can't get it to work.


Steve
 
S

seve

I found the answer...just had to search on the right words....

This works


=CONCATENATE(TEXT(F1+7,"mm/dd"), " - ",(TEXT(F2+7,"mm/dd")))
 
S

seve

I found the answer...just had to search on the right words....

This works


=CONCATENATE(TEXT(F1+7,"mm/dd"), " - ",(TEXT(F2+7,"mm/dd")))
 
G

Gary''s Student

In A1 enter:
=TEXT(DATE(2006,5,13+7*(COLUMN()-1)),"m/dd") & " - " &
TEXT(DATE(2006,5,13+7*(COLUMN()-1))+6,"m/dd")

and copy across
 
D

Don Guillett

for a formula try this idea where a10 contains 5/6
=TEXT($A$10+ROW(A1)*7,"mm/dd") & "-"&TEXT($A$10+ROW(A1)*7+6,"mm/dd")
I would probably do it with macro instead
 
Top