Try something like:

="FOR THE PERIOD OF " & Month(cell reference) & "/" & day(cell reference) &
"/" & year(cell reference)

HTH,
Paul


--

"Lori" wrote in message
...
I am trying to combine a text string ("FOR THE PERIOD OF "), then do a cell
reference to another sheet within the same workbook. The cell contains a
date. The result in the concatinated cell only displays as the date
(39366,
etc.). I've trying using format cell, using both the date option and the
special option with no success. Also tried both "=concatinate" and using
the
ampersand (&) with same (incorrect) result.