Use Text Function in your weekday formula.

=TEXT(WEEKDAY(A1),"DDDD")

The above function itself will result you the weekdays like this Monday,
Tuesday etc

If you want to show the weekdays in lower case the use the below:-
=LOWER(TEXT(WEEKDAY(A1),"DDDD"))
Result:- monday

If you want to show the weekdays in UPPER CASE the use the below:-
=UPPER(TEXT(WEEKDAY(A1),"DDDD"))
Result:- MONDAY

If you want to show the weekdays in Title Case the use the below:-
=PROPER(TEXT(WEEKDAY(A1),"DDDD"))
Result:- Monday

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Patrick Znaty" wrote:

I have a column containing weekdays derived from a date using the weekday
function. If I format these cells with "dddd" I will get monday, tuesday etc.
But I want the weekdays to be Monday, Tuesday etc. Anyway to do this as cell
formatting?