Day of week e.g. Sunday

Post Reply
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

Day of week e.g. Sunday

Post by Princy557 »

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

Princy557
Jossi
SoftMaker Volunteers
SoftMaker Volunteers
Posts: 1237
Joined: Fri Dec 05, 2003 10:47 pm
Location: Luebeck, Germany

Re: Day of week e.g. Sunday

Post by 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.
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

Re: Day of week e.g. Sunday

Post by 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.
:D
Regards

Princy557
Post Reply

Return to “PlanMaker 2018 for Windows”