Format a date within a Concatenate function

Adrae · Mar 26th, 2002, 10:25 AM

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 · Mar 26th, 2002, 10:30 AM

Quote:

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 · Mar 26th, 2002, 10:35 AM

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

Thanks

Aladin Akyurek · Mar 26th, 2002, 10:41 AM

Quote:

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 · Mar 26th, 2002, 10:42 AM

That did it! Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 10:25 AM	#1
Adrae Board Regular Join Date: Feb 2002 Location: Chicago, IL USA Posts: 306	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)")

Mar 26th, 2002, 10:35 AM	#3
Adrae Board Regular Join Date: Feb 2002 Location: Chicago, IL USA Posts: 306	How do I add that extra little bit on the end, (000's)? Thanks

Mar 26th, 2002, 10:42 AM	#5
Adrae Board Regular Join Date: Feb 2002 Location: Chicago, IL USA Posts: 306	That did it! Thanks