No confusion between Saturday and Sunday and Tuesday and Thursday?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Robbyn" wrote in message
...
Thanks!

"Gary's Student" wrote:

if(H12="","",LEFT(TEXT(H$12,"ddd")))
--
Gary's Student


"Robbyn" wrote:

Thanks much all! I went with the simplist formula:
=LEFT(TEXT(H$12,"ddd"))
One more quick question. If H$12 is blank, how do I make sure the
cell with
the formula remains blank? This didn't work:
=IF(LEFT(TEXT(L$12,"ddd"))="","",LEFT(TEXT(L$12,"d dd")))



"Robbyn" wrote:

Hi all,

I use =TEXT(H12,"dddd") to calculate the day of week for a date. Is
there
any way I can have the first letter of the day show, instead of the
whole
word?

Monday becomes M; Tuesday becomes T, etc.