Formula to add day in date display

[rizmomin]

Hello:
Please refer to attached file.
I have A1 = 11 and B1 = 2016
I have add formula in cell A8 = =A1&"/1/"&B1 to give A8 as 11/1/2016.
I need a way to have A8 as 11/1/2016 Tue as 1st Nov being Tuesday.
A9 thru down same way.
Let me know if you have any questions.
Thanks.

Riz

[JohnTopley]

In A8

=DATEVALUE(A1&"/01/"&B1)

Custom format cells as ddd dd/mm/yyyy

[Phuocam]

Or try this in A8:

=TEXT(DATE($B$1,$A$1,ROWS($A$8:A8)),"dddd dd/mm/yyyy")

Copy down.

[rizmomin]

Hello Phuocam:

Your solution works great.
I beleive John had misunderstood my thread and i know this is very easy for him.
Thanks a lot to both.

Riz

[Phuocam]

You are welcome!

[JohnTopley]

I did not misunderstand your requirement: merely correcting the date form in A8. If the formatted cells as I said you get your required result.

After nearly 3000 posts I thought you would be able to "interpret" my response.