View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
dranon dranon is offline
external usenet poster
 
Posts: 14
Default Formatting date as first letter of day only

On Mon, 20 Dec 2010 18:34:42 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:

On Mon, 20 Dec 2010 17:04:37 -0800, dranon
wrote:

On Sun, 19 Dec 2010 06:42:14 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadshee t.org wrote:

On Sun, 19 Dec 2010 02:40:09 -0800 (PST), Wouter HM
wrote:

Hi Gavin,

I created an other option:


=CHOOSE(WEEKDAY(B2;1);"S";"M";"T";"W";"T";"F"; "S")

where B2 holds the date.

So something without VBA


HTH,

Wouter

Thursday and Saturday and or Sunday need additional letters to
differentiate.

So it can never actually be only one letter per day.


You don't listen too good.


You're a goddamned idiot, boy. Go interlope somewhere else.

I was doing dates before you were even born.


LOL. And what does that have to do with the fact that you don't
listen too good? Get your head out of your ass and read what has been
written. And when you make a suggestion that is contrary to logic
after taking that into consideration, apologize for being the idiot
you are.