Converting Date to Day of the Week in Excel

In this tutorial, we will put the date we want to convert in cell A1 and the day in B1.

1. Enter the date you want to convert in cell A1.

Enter Date in Cell A1 in Excel

2. In cell B1, enter =TEXT(WEEKDAY(A1), “dddd”)

Scroll to Top