Date Formatting when using &

[Guest]

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

 

[Mladen_Dj]

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

 

[JMay]

In A3:

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