Convert Date To Day Of Week In Excel | Easy TEXT Function Tutorial For Beginners | Learn Excel 2026
📅 Want to know if a specific date is a Monday or a Sunday? Learn how to extract the Day Name from any Date in Excel using the TEXT function!
In this video, I show you the fastest way to convert dates (like 30/12/2025) into full day names (like "Tuesday") without looking at a calendar.
We use the simple =TEXT() formula. This function is powerful because it allows you to format dates exactly how you want them.
📘 *FORMULA EXPLAINED:*
=TEXT(Value, "Format_Code")
In this video, we used: *=TEXT(A2, "dddd")*
💡 *PRO TIP (Format Codes):*
*"ddd"* = Short Name (e.g., Mon, Tue, Wed)
*"dddd"* = Full Name (e.g., Monday, Tuesday, Wednesday)
*"mmmm"* = Full Month Name (e.g., January, February)
This trick is perfect for project managers, HR professionals tracking attendance, and anyone organizing schedules in Excel.
---
⏱️ *KEY MOMENTS IN THIS EXCEL TUTORIAL*
0:00 - Intro: Date Column vs Day Column
0:03 - Writing the =TEXT Formula
0:06 - Using "dddd" for Full Day Name
0:09 - Result: Tuesday
0:12 - Drag & Drop to Apply to All Dates
---
🚀 *RELATED SEARCH TERMS:*
how to get day of week from date in excel, extract day name from date, excel text function date, convert date to text excel, show day of week excel, excel date formulas, custom date formatting excel, find day from date, excel dddd format, date to day converter excel, excel tips and tricks 2026.
---
#Excel #ExcelTips #TextFunction #DateFormulas #ExcelTutorial #DataEntry #MicrosoftExcel #Spreadsheets #Productivity #LearnExcel #DayOfWeek #Office365 #TechSkills #AdminHacks #DataCleaning
---
*ABOUT THE CHANNEL:*
We simplify complex Excel tasks into quick, easy-to-follow tutorials. Whether you are a beginner or looking to sharpen your skills, subscribe for more tips on VLOOKUP, Pivot Tables, and Formatting!
Thanks for watching!
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Copyright Notice:-
Please feel free to leave me a notice if You find this upload inappropriate.
Contact me personally if You are against an upload in which You may have rights to the Images (or) music, instead of contacting YouTube about a Copyright Infringement.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Any content from this channel re-uploaded by other user without permission will be treated strictly and the channel/video will be suspended according to the YouTube community guidelines.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Channel Owner: Siddam Bharat
Website: http://siddam.com/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -