with activesheet
.range("a1").value = format(.range("b1"),"mm/dd/yyyy") _
& " to " _
& format(.range("b2"), "mm/dd/yyyy")
end with

But you could do the same thing with a formula in the cell:

=text(b1,"mm/dd/yyyy") & " to " & text(b2,"mm/dd/yyyy")



ll wrote:

How do you go about setting the value of one cell equal to a text
string of the value of one cell, &, and the value of another cell?
Specifically, I'm trying to refer to the date values of my begin and
end dates on my timesheet.

Thanks,
Louis

--

Dave Peterson