Answer Posted / Pankaj Kumar Tripathi
To show the weekday, use the WEEKDAY function. For example, if cell A1 contains a date, you could use `=TEXT(WEEKDAY(A1,2),"dddd")` to display the full name of the day (e.g., 'Tuesday'). If you want only the first three letters, use `=LEFT(TEXT(WEEKDAY(A1,2),"ddd"),3)`.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
