Absolutely correct, the fx isn't actually required.

Thanks for the follow-up |:)

"JE McGimpsey" wrote:

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.