August 1 2024 Day Of Week In Excel. Under category, click custom, and in the type box, type dddd for the full name of the day of the week (monday, tuesday, and so on), or ddd for the abbreviated name of the day of the week. To do this task, use.

It takes a date serial number or. Using “ddd” will return an abbreviated weekday, such as mon or tue.