Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Excel: Converted date to day of week but now want to convert that to text only

Copper Contributor

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!

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@jstumpff 

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").

Thanks so much. That got me to the answer I needed -- which was the text (not the formula) in the cell.  However, I copied the cells with the formula and used the Paste123 to get the text only of the day!

@jstumpff 

As a comment, if you want only to show weekday as the text, not to do other manipulation with that text, it's better to reference the date and apply to the cell "dddd" format. That could give more flexibility.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@jstumpff 

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").

View solution in original post