Get Day

Day of the Month

Use =DAY(A1) to get the day of a date entered in A1.

Weekday

Use =WEEKDAY(A1) then format as ddd or dddd

or

Use =TEXT(WEEKDAY(A1),"ddd") or =TEXT(WEEKDAY(A1),"dddd")