Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

=WEEKDAY(A1)

and formatting the cell as Date - user defined - "NNNN" The other answers are right too.

=Text(A1,"DDDD") will be the best one.