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?

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


    you can try:


    [COLOR="#0000FF"]=TEXT(A2,"dddd")[/COLOR]


    or simply


    =A2 then custom format cell as "dddd"

    Where there is a will there are many ways. Finding one that works for you is the challenge!