Formatting date as first letter of day only

[CellShocked]

LOL.

The gang boy retard lingo here says a lot about you, little boy.

And what does that have to do with the fact that you don't
listen too good?

I listen fine. Where is it that you seem to think I did not listen
good? It has more to do with the fact that you jack off at the mouth
good.

Get your head out of your ass and read what has been
written.

I wrote some of it, idiot. Unlike you, another mouthy little bitch,
contributing nothing, but jacking off at the mouth,like the mental
masturbator that you are.

And when you make a suggestion that is contrary to logic
after taking that into consideration, apologize for being the idiot
you are.

You are the idiot that did not read the entire thread. I already gave
solutions to the guy, and merely commented on the non-solution that was
given here.

If your head was not so far up your ass, you would know that it was
your character which YOU compromised by taking your head out of your ass
long enough to toss your lame, peanut gallery wanna be comment into the
thread, instead of actually contributing to the thread.

It might have had an inkling of validity if you had actually
contributed to the thread. As it stands, you do not even rate the monkey
slapping his little cymbals together, boy.

 

[GavinS]

=CHOOSE(WEEKDAY(B2;1);"Su";"M";"Tu";"W";"Th";"F";"Sa")

Gets the prize

Although
=MID("SMTWTFS",WEEKDAY(A1),1)
was good it could not handle the 2nd letter thing ie Sa

Thanks for every ones help

 

[dranon]

The gang boy retard lingo here says a lot about you, little boy.

Gang boy? My lord are you off base.

I listen fine. Where is it that you seem to think I did not listen
good?

You really expect me to do your work for you, brainless one? You
should live so long.

Your diatribe says more about you than me.

Some day you may grow up and learn a bit along the way.

Until then, I will comment when I feel like it and your silly
responses certainly won't have any impact on that.

You may continue if you wish. Some day I may even give you the last
word. Until then, be aware that if you post, I will reiterate your
brainless efforts.

I wrote some of it, idiot.

And no doubt just read the part that you wrote.

 

[CellShocked]

Gang boy? My lord are you off base.

So, "LOL" is "mature adult"? I don't think so.

 

[StickThatInYourPipeAndSmokeIt]

Your diatribe says more about you than me.

The immature horseshit I snipped that was your diatribe says mountains
about you.

Contribute or **** off. Oh... it's you... just **** off then, as you
are obviously incapable of contributing.

 

[Rick Rothstein]

=CHOOSE(WEEKDAY(B2;1);"Su";"M";"Tu";"W";"Th";"F";"Sa")

Gets the prize

Although
=MID("SMTWTFS",WEEKDAY(A1),1)
was good it could not handle the 2nd letter thing ie Sa

If you wanted to use MID with 1 and 2 letter abbreviations, you could do it
this way (note the strategically located spaces)...

=TRIM(MID("SuM TuW ThF Sa",2*WEEKDAY(A1)-1,2))

Rick Rothstein (MVP - Excel)

 

[dranon]

So, "LOL" is "mature adult"? I don't think so.

No, it means exactly what it says, that I was laughing out loud at
your stupity.

 

[dranon]

The immature horseshit I snipped that was your diatribe says mountains
about you.

Contribute or **** off. Oh... it's you... just **** off then, as you
are obviously incapable of contributing.

Name change to protect the stupid?

 

[CellShocked]

No, it means exactly what it says, that I was laughing out loud at
your stupity.

No, I was referring to the fact that using it in writing is immature.

Come back when your mental age exceeds that of someone just entering
puberty. Better yet, just squirm some more. I am sure many are amused.

You are proof that numerical age does not an adult make.

And no, pkb boy, I am referring to you, idiot.

 

[MassiveProng]

Name change to protect the stupid?

Having further problems with reading comprehension again, I see.

Here, idiot... try another.. maybe it will begin to sink in.

 

[dranon]

No, I was referring to the fact that using it in writing is immature.

Come back when your mental age exceeds that of someone just entering
puberty. Better yet, just squirm some more. I am sure many are amused.

You are proof that numerical age does not an adult make.

And no, pkb boy, I am referring to you, idiot.

LOL. At you. And you refer to me as immature? You haven't got a clue
and never will. When an acronym is nothing more than a literal
abbreviation it takes a truly insecure individual to render it gang
speak. How about GFY?

 

[My Name Is Tzu How Do You Do]

When an acronym is nothing more than a literal
abbreviation it takes a truly insecure individual to render it gang
speak.

Now, you do not even know what the meaning of the word "acronym" is.

And it was not I that "rendered it gangspeak". Pants down past the
asscrack retards like you did a fine job of that all by yourselves.

 

[dranon]

Now, you do not even know what the meaning of the word "acronym" is.

And it was not I that "rendered it gangspeak". Pants down past the
asscrack retards like you did a fine job of that all by yourselves.

Now your stupidity is overflowing. Besides your attempt to rewrite
history you now want to change the common definition of words.

Truly pathetic.

You really do need to learn to read.

 

[iumarabbas]

In various cells I have dates written in as dd/mm/yy format.

I would like to format this as d - that is the first of the day only.
For example 16/12/10 displayed as T (for Thursday).

How can I do this please

USE THIS CODE:

string stTodayDayFirstLetter = DateTime.Now.ToString("ddd").Substring(0, 1);