WEEKDAY function returns wrong day of the week

Hi Experts,

I am trying to find out the day of the week by using the WEEKDAY function, I want Monday to be day 1 and Sunday day 7, so I am entering my formula like this =WEEKDAY(A2,2)

I have attached the file I am using, kindly check and revert back to me with a solution, I am really confused why is it not working?

Thanks,
ExcelGuyB

Hi,

Why do you think the answers are incorrect? I randomly checked a few values, and the answers returned by the function seem fine to me. The error seems to be in the function used by you in the C column

Put this in C2 and drag down

=INDEX({"Mon";"Tue";"Wed";"Thu";"Fri";"Sat";"Sun"},B2)

If you want to see the weekday as a word, try:

Formula:

Please Login or Register  to view this content.

You're welcome.

You can only get the weekday as a number from the date. Given the setting you have used, Monday is weekday 1. You can't take that 1 and convert it a textual description ... unless you use it as an index as shown.

TEXT can be used to get the textual description. You could also just copy the date and use a custom format.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.