Forum Discussion
Solved
Excel: Converted date to day of week but now want to convert that to text only
I am working in Excel. How can I convert the day of the week (derived from a formula that takes the date and turns it into a day of the week) into text? Thanks for your help!
Let's say the formula with the day of the week is in D2.
In another cell, e.g. E2, enter the formula =TEXT(D2,"dddd") if you want the full name ("Thursday"), or =TEXT(D2,"ddd") if the want the abbreviated name ("Thu").
Let's say the formula with the day of the week is in D2.
In another cell, e.g. E2, enter the formula =TEXT(D2,"dddd") if you want the full name ("Thursday"), or =TEXT(D2,"ddd") if the want the abbreviated name ("Thu").