In today’s Excel Training video, we’ll show you how to extract the day of the week from a date using the built-in functions, specifically TEXT and WEEKDAY. Understanding the day of the week can be crucial for various applications, ranging from organizing schedules to analyzing trends over time. By employing these functions effectively, you can manipulate date-related data with precision, enhancing your ability to derive meaningful insights from your Excel spreadsheets.
Moreover, we’ll show you how to highlight specific days using conditional formatting, making it easier to identify and focus on particular days based on predefined criteria.
PSST, HEY, YOU
(YEAH, YOU!)
Want in on insightful videos, the latest tech developments, and epic exclusive content? Get all this and more as a member of our mailing list.
Resources
Day of week using TEXT (Mon, Tue, Wed…)
=TEXT(A1, "ddd")
Day of week using TEXT (Monday, Tuesday, Wednesday…)
=TEXT(A1, "dddd")
Day of week using WEEKDAY (1 [Mon], 2 [Tue], 3 [Wed]…)
=WEEKDAY(A1, 2)
Custom day of week using WEEKDAY
=CHOOSE(WEEKDAY(A1, 2), "Mon", "Tues", "Weds", "Thur", "Fri", "Sat", "Sun")