How to Find the Day of the Week From a Date in Microsoft Excel

Wed-Jan-2023
1

To find the day of the week from a date in Microsoft Excel, you can use the “TEXT” function along with the “WEEKDAY” function. Here are the steps:

  1. Enter the date in any cell in Excel. For example, enter “4/15/2023” in cell A1.
  2. In another cell, enter the formula “=TEXT(A1,”dddd”)”. This formula uses the “TEXT” function to convert the date in cell A1 to a day of the week, using the format “dddd” to display the full day name.
  3. Press enter to apply the formula. The result will be the day of the week for the date entered in cell A1. For example, “Saturday”.
  4. If you want to use the “WEEKDAY” function instead of the “TEXT” function, enter the formula “=WEEKDAY(A1)” in a cell. This formula will return a number from 1 to 7 that represents the day of the week, with Sunday being 1 and Saturday being 7.
  5. If you want to display the day name instead of the number, modify the formula to “=TEXT(A1,”dddd”)” or “=TEXT(A1,”ddd”)” to display the abbreviated day name.

Note: In both formulas, “A1” refers to the cell containing the date that you want to convert. You can modify the formula as needed to refer to a different cell or range of cells.