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=&]WeekdayName( weekday , abbreviate , firstdayofweek )
[FONT=&]Yet when I type the following line into a cell, I get an error:
[FONT=&]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?