EXCEL

[Nick Shipp]

HELP NEEDED PLEASE

I have a spreadsheet with multiple columns and rows.

I need to combine the day and date from two columns into one for a graph label.

I have column B with the days of the week stored as text and column C that stores the actual date dd/mm/yy of the day in question.

I need a column A that joins the content to read Monday 15/10/18

I have tried CONCAT and combime but my date field always converts back to a number?

[#2]

Hi Nick,

Try as

=B1 & " " & TEXT(C1,"dddd dd/mm/yy")

[#3]

Hi Sergei

Tried it and it returns

Tuesday Tuesday 31/07/18

Wednesday Wednesday 01/08/18

Thursday Thursday 02/08/18

Friday Friday 03/08/18

Monday Monday 06/08/18

[#4]

Nick, sorry, didn't read carefully, thought in B you have week numbers. When you may ignore column B, just

=TEXT(C1,"dddd dd/mm/yy")

or alternatively

=B1 & " " & TEXT(C1,"dd/mm/yy")

In general what you have in B could be received as

=TEXT(C1,"dddd")

you don't need that column at all

[#5]

Many thanks Sergei, I have it now.

Your help is very much appreciated.

[#6]

Nick, you are welcome