Formatting day of the week

[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,

 

[Dave Peterson]

You could use another column with a formula like:

=left(text(a2,"ddd"),1)

 

[Jordon]

That saved me a bunch of work. Thanks Dave!

 

[Paul Hyett]

In microsoft.public.excel on Wed, 26 Dec 2007, Jordon

That saved me a bunch of work. Thanks Dave!

Though with only one letter, how could you tell the difference between
Tuesday/Thursday & Saturday/Sunday?

 

[carlo]

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

 

[Jordon]

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.