Stored as date format, cut at comma

If you go to Sales in that attached ss, you will see the cell i have highlighted yellow, can someone make that cut Monday out of col a, but for consistency down the range, cut just before comma, also i belive that the col a is stored as date, causing it to return digits

Many thanks
The-Howl-Sales-Kat.xlsx
Seamus2626Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
BlueYonderConnect With a Mentor Commented:
Here is the formula =CHOOSE(WEEKDAY(A2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
0
 
Saqib Husain, SyedEngineerCommented:
=TEXT(A2,"dddd")
0
 
Seamus2626Author Commented:
Thanks!
0
 
Saqib Husain, SyedEngineerCommented:
Hi, what was wrong with my formula?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.