Day Question

[Guest]

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.

 

[Roger Govier]

=LEFT(TEXT(H12,"ddd"))

 

[Guest]

=left(TEXT(H12,"DDDD"),1)

 

[Domenic]

Try...

=LEFT(TEXT(H12,"ddd"))

Hope this helps!

 

[CLR]

=LOOKUP(WEEKDAY(H12),{1,2,3,4,5,6,7},{"S","M","T","W","T","F","S"})

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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,"ddd")))

 

[Guest]

if(H12="","",LEFT(TEXT(H$12,"ddd")))

 

[Guest]

Thanks!

if(H12="","",LEFT(TEXT(H$12,"ddd")))

 

[Domenic]

Try...

=IF(N(L$12),LEFT(TEXT(L$12,"ddd")),"")

Hope this helps!

 

[Ragdyer]

No confusion between Saturday and Sunday and Tuesday and Thursday?