I have a cell called A29 that gets its value from a the myfiled through a vba prompt when opening, I have the following cells below it that are just "=A29+1", "A29+2", resulting in a series of dates from A29 to A33. I would like to concatenate the dates in A29 & A33 to one cell, so that the result would look like : xx/xx/xxxx - xx/xx/xxxx
Is this possible? I understand that the "/" is causing some issues.