How to retrieve days for dates

[asksign]

Hi,

How to retrieve days for dates
Requirement given below.
Available date, expected days.

[TABLE="width: 159"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Day[/TD]
[/TR]
[TR]
[TD]13-10-2018[/TD]
[TD]Saturday[/TD]
[/TR]
</tbody>[/TABLE]

can any one help me in this.

 

[footoo]

Enter in B1 : =A1
Format B1 as : dddd

Or in B1 : =TEXT(A1,"dddd")

Or you could format A1 as : dd-mm-yyyy, dddd