How do I get a cell to show the day of the week when date entered

C

Captain

How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.
 
R

Ron Coderre

Try this:

Select the cell(s) that are impacted
Format>Cells>Number tab
Category: Custom

Type: ddd
Returns: Mon, Tue, etc

Type: dddd
Returns: Monday, Tuesday, etc

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
S

Sumuwin

Captain said:
How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.
Click to expand...


select Format, Cells, (Number) ,Custom and type ddd in the Type box
 
L

L. Howard Kittle

Hi Captn'

Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005


HTH
Regards,
Howard
 
C

Captain

Captain said:
How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.
Click to expand...

Thanks! Is there a way to get the week # for a specific date?
 
C

Captain

L. Howard Kittle said:
Hi Captn'

Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005


HTH
Regards,
Howard



Thanks!
How do I get a cell to show the Week Number for specific dates?
Click to expand...
Thanks again
Captain
 
P

Peo Sjoblom

Unless the Captain is English, then it would return TUE

<bg>

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top