please don't use all caps when writing messages - it is considered shouting
in these groups and makes things harder to read.
If you choose format / cells - number tab & click on the custom type
you can enter
dddd
into the type field which will cause the dates to appear as the day of the
week only.