[SOLVED] CONCATENATE And Date Format

[Joseph Zuraski II]

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

[Gary''s Student]

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

[SteveG]

Joseph,

=CONCATENATE(TEXT(A4,"mm/dd/yyyy")," - ",TEXT(B4,"mm/dd/yyyy"))

Cheers,

Steve

[CLR]

=TEXT(A1,"mm/dd/yyyy")&" - "&TEXT(B1,"mm/dd/yyyy")

Vaya con Dios,
Chuck, CABGx3



"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