WEEKDAYNAME function not working... error #NAME? (Excel 2013)

Column A has a date. I want Column B to tell me what day of the week it is.

If I Google something generic such as "excel vba weekday as name", multiple results are returned. I'm looking for an elegant, in-line solution involving a formula directly in the cell (no VBA modules, etc.).

Many, many sites say that I can use a function called "WeekDayName", including MSDN:

[FONT=&amp]Syntax[/FONT]
[FONT=&amp]WeekdayName( weekday , abbreviate , firstdayofweek )

https://msdn.microsoft.com/en-…rary/office/gg278600.aspx[/FONT]
[FONT=&amp]Yet when I type the following line into a cell, I get an error:
[/FONT]
[FONT=&amp]=WeekDayName(Now)[/FONT]
[FONT=&amp]What am I missing? The function name does not even show up when I start typing... can it ONLY be used in a VBA module?

[/FONT]Edit: do I just format column B as "dddd"? Is that the simplest solution?