Date Formatting when using &

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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

Regards
 
Back
Top