![]() However, you will notice that instead of displaying “Tuesday” in cell C2, it gives you “Monday”. If you want to abbreviate the weekday to the first three letters such as “Mon”, “Tue”, etc, use “ddd” instead. This will show your weekday as “Monday”, “Tuesday”, and so on. Select More number formats and that should bring you to the Format Cells window as well. Alternatively, you can go to the HOME tab and click on the dropdown button in the Number section. Click on CTRL + 1 and that will display the Format Cells window.Left click on the cell containing the weekday number.To change the weekday number to a name, you can use Excel’s custom formatting. In this report, instead of the weekday numbers, we want to display the weekday names so that it displays as Sunday, Monday, and so on. Changing the return type of the WEEKDAY() function to 1, gives you a weekday number of 1 instead of 2. ![]() This results to a 2 since falls on a Tuesday. To see how this works, use the WEEKDAY() function for in cell A2 using a week that starts on a Monday: Cell A2 =WEEKDAY(A2,2) If you want it to start on a Monday, for example, you should use 2 as the return type.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |