Formatting date as first letter of day only
On Sun, 19 Dec 2010 06:42:14 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. 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.
|