Day and Date in same cell

[LeeBillington]

Hi guys,
So i am using this formula below to merge a cell with a day in (A1) and date in (B1) but i am getting " Tuesday 42969 " is there anyway round this?

=(A1&" "&B1)

[Root_]

Try custom-formatting cell B1 as dddd d-mmm-yyyy.

Or try =TEXT(B1,"dddd d-mmm-yyyy")

[MrShorty]

What is the purpose of the concatenation? Date serial number 42969 (the value apparently in B1) corresponds to the date of Tuesday 22 August 2017. You should not need to concatenate "Tuesday" onto that serial number, since Excel already knows that it represents a Tuesday. I would just format B1 with a long date format that includes the weekday. If you are trying to store the same value in another cell, you could do =B1 and change the format to be a long date.

I would suggest reviewing something like this to understand how Excel stores and works with dates/times as serial numbers: http://www.cpearson.com/Excel/datetime.htm

[LeeBillington]

Ah yeah they both completely make sense, thankyou!