12/03/2026
If you are still checking dates manually, you are doing it the hard way.
WEEKDAY, CHOOSE and TEXT can help you find out the actual day name easily.
WEEKDAY tells you which day of the week a date falls on. CHOOSE turns that number into an actual name. TEXT does the whole thing in one shot.
Together these functions unlock something you can use quite often in your spreadsheets. Sales reports by day. Shift planning. Attendance tracking. Any time you need to know not just when something happened but on which day it happened.
And yes, there is a practical example at the end of my new tutorial. Cinema ticket sales data analyzed by day of the week, with a chart to visualize it. 📅
Watch it now and tell me in the comments how you work with day names 👇
https://youtu.be/nArwqN4Swyk
In this Excel tutorial you will learn how to extract the day name from any date. We cover three different approaches so you can pick the one that fits your n...
