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]WeekdayName( weekday , abbreviate , firstdayofweek )

    [FONT=&amp]Yet when I type the following line into a cell, I get an error:

    [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:


    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!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!