Date format

[dalymjl]

I don't see any option under format/number/date to display the name o
the day.

mjd

 

[Ruthki]

=WEEKDAY() will return a number representing a day of the week (eg 1 =
sunday, 2 - monday etc)

You could then use a lookup or if statement to turn this into the name
of the day.

R

 

[bill k]

<format><cells><number><custom>

type dddd, d-mmm-yyyy