Formatting date as first letter of day only

  • Thread starter Thread starter GavinS
  • Start date Start date
LOL.
Click to expand...


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?
Click to expand...


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.
Click to expand...

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.
Click to expand...

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.
 
=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
 
The gang boy retard lingo here says a lot about you, little boy.
Click to expand...

Gang boy? My lord are you off base.

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

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.
Click to expand...

And no doubt just read the part that you wrote.
 
Your diatribe says more about you than me.
Click to expand...

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.
 
=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
Click to expand...

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)
 
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.
Click to expand...

Name change to protect the stupid?
 
No, it means exactly what it says, that I was laughing out loud at
your stupity.
Click to expand...

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.
 
Name change to protect the stupid?
Click to expand...

Having further problems with reading comprehension again, I see.

Here, idiot... try another.. maybe it will begin to sink in.
 
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.
Click to expand...

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?
 
When an acronym is nothing more than a literal
abbreviation it takes a truly insecure individual to render it gang
speak.
Click to expand...


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, 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.
Click to expand...

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.
 
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
Click to expand...

USE THIS CODE:

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