Day Question
 

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.

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

--
Regards

Roger Govier


"Robbyn" wrote in message
...
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.

=left(TEXT(H12,"DDDD"),1)
--
Gary's Student


"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.

Try...

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

Hope this helps!

In article ,
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.

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

Vaya con Dios,
Chuck, CABGx3




"Robbyn" wrote in message
...
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.

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.

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.

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.

Try...

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

Hope this helps!

In article ,
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.

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.