Day of week e.g. Sunday

[Princy557]

Hi,
How do you display in a cell the day of the week in words Saturday, Sunday or Sat, Sun etc

[Jossi]

Format > Cell..., tab "Number format", go in the left field to "Custom" and define the format as DDDD (for "Sunday" etc.) or DDD (for "Sun" etc.). Of course, the cell content must be a WEEKDAY function.

[Princy557]

Hi Jossi,
Thank you for the help there, I'd tried something similar but just didn't for for me, Can see the error of my ways now.
Thanks again.