No need for a worksheet function, just use

B10: =A10

and format it with Format/Cells/Number/Custom dddd



In article ,
"CyberTaz" wrote:

One way is to use the WEEKDAY() function and apply a custom format to the
cells using dddd for full spelling, ddd for 3-char. abbreviations.