Forum Discussion
EXCEL
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 st...
Hi Nick,
Try as
=B1 & " " & TEXT(C1,"dddd dd/mm/yy")
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 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
Many thanks Sergei, I have it now.
Your help is very much appreciated.
