Converting Date to Day of the Week in Excel

October 2, 2012 by Editorial Staff Leave a Comment

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

Filed Under: How-Tos Tagged With: cell A1, cell B1, Converting, Day of the Week, dddd, Week, WEEKDAY, width

About Editorial Staff

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