Format a date within a Concatenate function

[Adrae]

For this formula, the value in Sheet1!E4 is a date (MM/DD/YY). It pulls it as a number here. Anyway to format this as a date.
Thanks

=CONCATENATE("Flash Report for the Week Ended", " ",Sheet1!E4, " ","(000's)")

 

[Aladin Akyurek]

On 2002-03-26 09:25, Adrae wrote:
For this formula, the value in Sheet1!E4 is a date (MM/DD/YY). It pulls it as a number here. Anyway to format this as a date.
Thanks

=CONCATENATE("Flash Report for the Week Ended", " ",Sheet1!E4, " ","(000's)")

Try:

="Flash Report for the Week Ended "&TEXT(Sheet1!E4, "mm/dd/yy")

 

[Adrae]

How do I add that extra little bit on the end, (000's)?

Thanks

 

[Aladin Akyurek]

On 2002-03-26 09:35, Adrae wrote:
How do I add that extra little bit on the end, (000's)?

Thanks

Not sure I understand, but is it:

="Flash Report for the Week Ended "&TEXT(Sheet1!E4, "mm/dd/yy")&"(000's)"

 

[Adrae]

That did it! Thanks