To get the day of the week in a cell you have two choices. You can use a format or a formula.

Format Method

You can use a custom format to display the day of the week of a date. To show the short name use ddd to show the full name use dddd. See the two examples below.

Formula method

If you want to use the Day name as text use the TEXT function to convert it to text. The formulas used in the image below are

Cell E2

=TEXT(A2,"ddd")

Cell F2

=TEXT(A2,"dddd")

Cell G2

=TEXT(A2,"ddd dd/mm/yy")

Note: the format cells (columns B and C) are right aligned as dates are treated as numbers. The TEXT function cells (columns E, F and G) are left aligned because the TEXT function returns a text result.

If you wanted to show just the first letter of the day eg M for Monday for a roster or a chart, you could use the following formula

=LEFT(TEXT(A2,"ddd"))