Formatting day of the week

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jordon - 26 Dec 2007 18:14 GMT

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,

--
Jordon

Reply to this Message

Dave Peterson - 26 Dec 2007 18:27 GMT

You could use another column with a formula like:

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

> 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
[quoted text clipped - 4 lines]
> --
> Jordon

Signature

Dave Peterson

Reply to this Message

Jordon - 26 Dec 2007 18:44 GMT

That saved me a bunch of work. Thanks Dave!

--
Jordon

> You could use another column with a formula like:
>
> =left(text(a2,"ddd"),1)
>
> Dave Peterson

> > 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)?

Reply to this Message

Paul Hyett - 27 Dec 2007 07:49 GMT

In microsoft.public.excel on Wed, 26 Dec 2007, Jordon
<jordon.haguewood@gmail.com> wrote :

>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?

>> You could use another column with a formula like:
>>
[quoted text clipped - 5 lines]
>> > of the day, but is there a way to show only the first letter of the
>> > day (Mon = M, Tue = T)?

Signature

Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Reply to this Message

carlo - 27 Dec 2007 07:55 GMT

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

> In microsoft.public.excel on Wed, 26 Dec 2007, Jordon
> <jordon.haguew...@gmail.com> wrote :
[quoted text clipped - 16 lines]
> --
> Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Reply to this Message

Jordon - 27 Dec 2007 19:58 GMT

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.

Signature

Jordon

> Though with only one letter, how could you tell the difference between
> Tuesday/Thursday & Saturday/Sunday?
[quoted text clipped - 8 lines]
>>> > of the day, but is there a way to show only the first letter of the
>>> > day (Mon = M, Tue = T)?

Reply to this Message