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
|