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”)

About Editorial Staff

Editorial Staff at KoolShiz is a team of WordPress lovers led by RJ. Page is maintained by RJ