![]() ![]() In this format, there is no need for any kind of formula to apply. Long Date format is one of the easiest formats to display the day of the week in Excel. Show Day of Week from Date Using Long Date Format SWITCH function takes this number and finds the string from the list and converts it into ‘ Fri’ which is the shorter version of Friday.Ħ. In cell C9, the WEEKDAY function returns 6 for the first date and the Secondly, the SWITCH function selects the string from the string list and converts the number into text format. By default, it starts on Sunday and the last day of the week is Saturday. The WEEKDAY function provides the number of the corresponding days.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |