By using a single quote (apostrophe), you are forcing a string rather than a
real date.


If you want to omit the single quote, then use the TEXT() function:

=CONCATENATE(TEXT(A4,"m/d/yyyy")," - ",TEXT(B4,"m/d/yyyy"))
--
Gary's Student


"Joseph Zuraski II" wrote:

I've always been doing formatting as =CONCATENATE(A4," - ",B4) where value is
'12/20/2006 on A4 and '12/31/2006 on B4 (12/20/2006 - 12/31/2006 printed
format).

Without the ' on the formula it becomes numerical (39071 - 39082). Is there
a way to make it read (12/20/2006 - 12/31/2006) without the ' symbols?

Thanks,

Joseph Zuraski II