Find Day from Date in Excel

Introduction to Finding Day from Date in Excel

When working with dates in Excel, it’s often necessary to extract specific information, such as the day of the week. Excel provides several functions to achieve this, including the TEXT, WEEKDAY, and DAY functions. In this blog post, we’ll explore how to find the day from a date in Excel using these functions.

Using the TEXT Function

The TEXT function is a versatile function that can be used to extract the day of the week from a date. The syntax for the TEXT function is TEXT(date, format), where date is the date you want to extract the day from, and format is the format you want to use to display the day. To extract the day of the week, you can use the following formats:

• “dddd” to display the full day name (e.g., Monday, Tuesday, etc.)
• “ddd” to display the abbreviated day name (e.g., Mon, Tue, etc.)

For example, if you have a date in cell A1, you can use the following formula to extract the full day name:

=TEXT(A1, “dddd”)

Using the WEEKDAY Function

The WEEKDAY function returns a number representing the day of the week, where Sunday is 1 and Saturday is 7. The syntax for the WEEKDAY function is WEEKDAY(date, [return_type]), where date is the date you want to extract the day from, and [return_type] is an optional argument that specifies the return type. If you omit the [return_type] argument, the function returns a value between 1 (Sunday) and 7 (Saturday).

For example, if you have a date in cell A1, you can use the following formula to extract the day of the week as a number:

=WEEKDAY(A1)

You can then use the CHOOSE function to convert the number to a day name:

=CHOOSE(WEEKDAY(A1), “Sunday”, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”)

Using the DAY Function

The DAY function returns the day of the month, which is not exactly what we need to find the day of the week. However, you can use the DAY function in combination with the WEEKDAY function to achieve the desired result.

For example, if you have a date in cell A1, you can use the following formula to extract the day of the week:

=WEEKDAY(A1)&” “&DAY(A1)&” “&MONTH(A1)&” “&YEAR(A1)

This formula returns a string that includes the day of the week, day of the month, month, and year.

Example Use Cases

Here are some example use cases for finding the day from a date in Excel:

• Scheduling: You can use the TEXT function to extract the day of the week and create a schedule that takes into account the day of the week.
• Reporting: You can use the WEEKDAY function to extract the day of the week and create reports that summarize data by day of the week.
• Automation: You can use the DAY function in combination with other functions to automate tasks that depend on the day of the week.

Date	Day of the Week
2022-01-01	Saturday
2022-01-02	Sunday
2022-01-03	Monday

📝 Note: Make sure to format the date cells in the correct format (e.g., YYYY-MM-DD) to ensure that the functions work correctly.

In summary, finding the day from a date in Excel can be achieved using various functions, including the TEXT, WEEKDAY, and DAY functions. By understanding how to use these functions, you can create more efficient and effective workflows in Excel. To recap, the key points to take away are the use of the TEXT function to extract the full day name, the WEEKDAY function to extract the day of the week as a number, and the DAY function in combination with other functions to achieve more complex tasks.