Dates in a text string?
 

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

Dates in a text string?
 

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

Dates in a text string?
 

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

Dates in a text string?
 

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
--
Gary's Student


"seve" wrote:

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

Dates in a text string?
 

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

--
Don Guillett
SalesAid Software

"seve" wrote in message
oups.com...
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

Dates in a text string?
 

Thank you Don and Gary's!

Steve