How to get Weekday name for a given date
Автор: Tech Sessions
Загружено: 2025-05-10
Просмотров: 78
Описание:
Get Weekday from Date in Excel (dd.mm.yyyy Format)
In this quick Excel tutorial, learn how to extract the weekday name from a date formatted as dd.mm.yyyy using a simple formula! Whether you're working with European-style dates or importing data from other sources, this trick will help you convert and read weekday names easily.
🧮 Formula used:
=TEXT(DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2)), "ddd")
💡 What you'll learn:
Convert text-formatted dates to Excel-recognized dates
Use `TEXT`, `DATE`, `LEFT`, `MID`, and `RIGHT` functions effectively
Display the weekday as Mon, Tue, Wed, etc.
👍 Like the video if you find it helpful
🔁 Share it with friends and colleagues
✅ Subscribe for more Excel tips and tricks
🔔 Don’t forget to turn on the bell icon to stay updated!
Facebook Page:
https://www.facebook.com/profile.php?...
#ExcelTips #ExcelFormula #ExcelShorts #ExcelWeekday #LearnExcel #ExcelTutorial #ExcelDateFormat #ExcelFunctions #TextFunction #DateFunction #MicrosoftExcel #ExcelHacks
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: