How to Get the Day of the Week from a Date in Excel (Sunday, Monday, etc.)

Learn how to extract the full or abbreviated day name from a date in Excel using the TEXT function with easy formulas.

369 views

To get the day of the week from a date in Excel, use the following formula: `=TEXT(date, "dddd")` for the full name (e.g., Sunday) or `=TEXT(date, "ddd")` for an abbreviated name (e.g., Sun). For example, if your date is in cell A1, you can enter `=TEXT(A1, "dddd")` to display the full day name. This formula effectively converts the date into the day of the week, making your data more comprehensible.**

FAQs & Answers

  1. What formula shows the day of the week from a date in Excel? Use =TEXT(date, "dddd") to display the full day name or =TEXT(date, "ddd") for the abbreviated day name.
  2. Can I get just the weekday abbreviation in Excel? Yes, use =TEXT(date, "ddd") to get an abbreviated weekday name like Sun or Mon.
  3. How do I apply the day name formula to multiple cells? Enter the formula in the first cell and then drag the fill handle down to apply it to other cells.

Watch More

For more Excel tips on date and time functions, check out our related videos on how to calculate weekdays, extract months, and customize date formats to enhance your data management skills.

  1. How to Calculate Monday from Sunday Date in Excel Easily Learn how to calculate the Monday of a week from a given Sunday's date in Excel using simple formulas for accurate weekly date calculations.
  2. What Day Number Does Sunday Represent in Excel's WEEKDAY Function? Learn how Sunday is represented in Excel's WEEKDAY function using different numbering systems for accurate date calculations.
  3. How to Find the Date of the Next Sunday in Excel Using a Formula Learn the Excel formula to calculate the next Sunday's date automatically using TODAY() and WEEKDAY() functions.
  4. How to Calculate Mondays to Saturdays in Excel Using NETWORKDAYS Function Learn how to calculate Mondays to Saturdays in Excel with the NETWORKDAYS function, including excluding Sundays and holidays.
  5. How to Calculate the Number of Sundays Between Dates in Excel Learn the Excel formula to count Sundays between two dates using SUMPRODUCT and WEEKDAY functions for accurate results.
  6. How to Identify Weekends in Excel Using Formulas Learn how to use Excel formulas like NETWORKDAYS and TEXT to identify weekends and workdays efficiently.
  7. How to Calculate Days Excluding Sundays in Excel Using NETWORKDAYS.INTL Learn how to count days excluding Sundays in Excel with the NETWORKDAYS.INTL function for accurate weekday calculations.
  8. How to Extract Day Name in SQL: A Step-by-Step Guide Learn how to easily get the day name in SQL using DATENAME and DAYNAME functions. Perfect for data organization and queries!
  9. How to Find the Day of the Week for a Date in SQL Using DAYNAME Learn how to find the day of the week from a date in SQL with DAYNAME and DAYOFWEEK functions. Easy examples included.
  10. How to Calculate Calendar Week Numbers in Excel Using WEEKNUM Formula Learn how to use the WEEKNUM formula in Excel to find the calendar week number for any date quickly and accurately.
  11. How to Calculate Weekends Between Dates in Excel Using Formulas Learn how to calculate the number of weekend days between two dates in Excel using simple formulas like NETWORKDAYS and DAYS.
  12. How to Count Days in a Week in Excel Using NETWORKDAYS Function Learn how to count weekdays and total days between dates in Excel with NETWORKDAYS and simple date subtraction formulas.