Showing The Day from Date Given in Excel

In Microsoft Excel if you want to now what day from date, month, and year given,  for example if you want to know the day your grand mother was born,  it's very easy. just set  the cell using cell format menu.

Run Ms Excel
Give the name of rows for example Date and Day
Date is  for entering date month year
Day is for showing the Day name

In the B2 cell write: =b1  then hit the Enter key

Now right-click the b2 cell 
Click Format Cells

Format Cells window will appear
At Number tab, choose Custom
Do manual entry for type, write dddd , (see the figure), click OK

Now you can try to enter the date and will know the day of that date.

Good Luck.