Date Formatting when using &
 

A1 is currently populated with a date, custom formatted as dd-mmm-yy. A2 is
populated with =text(a1,"DDDD") to show what day this is.

What I am wanting to do is put them both togther to show the Day in text
along with the date as custom format dd-mmm-yy. I have currently entered:

=a2&" "&a1, but this shows thae date as a number. How can I format it so it
show as I require it or is there a format to show it as this anyway?

regards

Date Formatting when using &
 

On Mar 21, 12:54 pm, The Rook
wrote:
A1 is currently populated with a date, custom formatted as dd-mmm-yy. A2 is
populated with =text(a1,"DDDD") to show what day this is.

What I am wanting to do is put them both togther to show the Day in text
along with the date as custom format dd-mmm-yy. I have currently entered:

=a2&" "&a1, but this shows thae date as a number. How can I format it so it
show as I require it or is there a format to show it as this anyway?

regards

Use custom number format "dd-mmmm-yy dddd", and theres no neeed for
formulas.

Regards
--
Mladen
http://excelancije.bloger.hr

Date Formatting when using &
 

In A3:

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

"Mladen_Dj" wrote in message
ups.com:

On Mar 21, 12:54 pm, The Rook
wrote:
A1 is currently populated with a date, custom formatted as dd-mmm-yy. A2 is
populated with =text(a1,"DDDD") to show what day this is.

What I am wanting to do is put them both togther to show the Day in text
along with the date as custom format dd-mmm-yy. I have currently entered:

=a2&" "&a1, but this shows thae date as a number. How can I format it so it
show as I require it or is there a format to show it as this anyway?

regards

Use custom number format "dd-mmmm-yy dddd", and theres no neeed for
formulas.

Regards
--
Mladen
http://excelancije.bloger.hr