=TEXT(A2,"m/dd/yy")&"-"&TEXT(B2,"m/dd/yy")
but please don't merge cells.
Concatenating the contents is fine, but merging cells causes countless
problems (as the archives of the group will show).
--
David Biddulph

"Need Letters in the Columns"
wrote in message
...
Hello, I would like to Merge to cells with dates to create a date range
example

A B c
dstartdate denddate Date Range

8/25/2008 9/21/2008 8/25/09-9/21/08

If I use the formula =A2&"-"&B2 I have to put a (') in front of each date
in
column A and B otherwise it comes out as unformatted numbers and I can't
use
the format to date to fix it.