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