Dates in a text string?

Giganews Newsgroups
Subject: Dates in a text string?
Posted by:  seve (scooks…
Date: 21 May 2006


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?


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.