Formatting day of the week

  • Thread starter Thread starter Jordon
  • Start date Start date
J

Jordon

I know that formatting a date with ddd shows the first three letters
of the day, but is there a way to show only the first letter of the
day (Mon = M, Tue = T)?

TIA,
 
In microsoft.public.excel on Wed, 26 Dec 2007, Jordon
That saved me a bunch of work. Thanks Dave!
Click to expand...

Though with only one letter, how could you tell the difference between
Tuesday/Thursday & Saturday/Sunday?
 
If you don't have enough space and you do the days continually it's no
problem to distinguish between Tuesday (M T W) and Thursday (W T F).

Saw that already plenty of times.

cheers Carlo
 
I'm using conditional formatting to get columns that
denote weekends to shade themselves gray and since
Saturday and Sunday both start with S it looks fine.

It's an attendance spreadsheet with employees in rows
and days of the month in columns. There are 12 sheets
(months) that link to a recap sheet. All I do is put
the first day of the year in the recap sheet and all
of the months are adjusted automatically with the
correct day designator (M, T, W, T, F, S, S) and
weekends get shaded where they should be.
 
Back
Top