Display Day Name from a date cell

This formula can put the day name into a cell when pointed towards a cell with a date in it.

CHOOSE(WEEKDAY(cell ref), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")

Code Snippits