In this tutorial, you will learn how to calculate day of week in #Excel by using the TEXT function. If your date is on A2, click on B2. Type =TEXT((A2), "ddd"). Press "Enter". This will display the calculation. ddd will give you the first three letters of the weekday name. Double-click on the bottom-right corner of the cell to apply the formula to the rest of the cells in the column. dddd will give you the full day name. d will give you the date. mmmm will give you the full month name. yyyy will