Forum Discussion

Nick Shipp's avatar
Nick Shipp
Copper Contributor
Oct 17, 2018

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 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?

excel
Formulas and Functions

5 Replies

    • Nick Shipp's avatar
      Nick Shipp
      Copper Contributor
      Oct 17, 2018

      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
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Oct 17, 2018

        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