How do I show weekday in excel?
- 1 Answers
- 732 Views
- I also Faced
- E-Mail Answers
How do I show weekday in excel?..
Answer / 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 |
More MS Excel Microsoft Interview Questions
How do you summarize?
What is the left function?
What does a spreadsheet contain?
Can you search multiple tabs in excel?
How do you use range in excel?
How many sheets can you have in excel?
How do you add a validation in excel?
What does the indirect function do in excel?
What is the shortcut for clear formatting?
How do you put a formula in a spreadsheet?
Is ms excel a dbms?
How do I use trim function in excel?
MS Excel Microsoft 
