software

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.

Try this:

Select the cell(s) that are impacted
Formatgt;Cellsgt;Number tab
Category: Custom

Type: ddd
Returns: Mon, Tue, etc

Type: dddd
Returns: Monday, Tuesday, etc

Does that help?

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

XL2002, WinXP-Proquot;Captainquot; wrote:

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


Originally Posted by CaptainHow 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.select Format, Cells, (Number) ,Custom and type ddd in the Type box.
Hi Captn'

Try =TEXT(A1,quot;dddquot;) which will return SUN, not MON for 1/2/2005HTH
Regards,
Howard

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


quot;Captainquot; wrote:

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

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

You'd think that was an easy question, right?

Check Chip Pearson's website for the range of answers....

www.cpearson.com/excel/weeknum.htm

Does that help?

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

XL2002, WinXP-Proquot;Captainquot; wrote:

gt;
gt;
gt; quot;Captainquot; wrote:
gt;
gt; gt; How do I get a cell to show the day of the week when date entered.
gt; gt; Example:A1 = 01/02/2005, A2 should Show Monday or MON.
gt; gt; I have Excel 2000.
gt;
gt; Thanks! Is there a way to get the week # for a specific date?



quot;L. Howard Kittlequot; wrote:

gt; Hi Captn'
gt;
gt; Try =TEXT(A1,quot;dddquot;) which will return SUN, not MON for 1/2/2005
gt;
gt;
gt; HTH
gt; Regards,
gt; Howard
gt;
gt; quot;Captainquot; gt; wrote in message
gt; ...
gt; gt; How do I get a cell to show the day of the week when date entered.
gt; gt; Example:A1 = 01/02/2005, A2 should Show Monday or MON.
gt; gt; I have Excel 2000.
gt;
gt; Thanks!
gt; How do I get a cell to show the Week Number for specific dates?
Thanks again
Captain

Unless the Captain is English, then it would return TUE

lt;bggt;

--
Regards,

Peo Sjoblom

(No private emails please)quot;L. Howard Kittlequot; gt; wrote in message
...
gt; Hi Captn'
gt;
gt; Try =TEXT(A1,quot;dddquot;) which will return SUN, not MON for 1/2/2005
gt;
gt;
gt; HTH
gt; Regards,
gt; Howard
gt;
gt; quot;Captainquot; gt; wrote in message
gt; ...
gt;gt; How do I get a cell to show the day of the week when date entered.
gt;gt; Example:A1 = 01/02/2005, A2 should Show Monday or MON.
gt;gt; I have Excel 2000.
gt;
gt;

quot;Ron Coderrequot; wrote:

gt; You'd think that was an easy question, right?
gt;
gt; Check Chip Pearson's website for the range of answers....
gt;
gt; www.cpearson.com/excel/weeknum.htm
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Captainquot; wrote:
gt;
gt; gt;
gt; gt;
gt; gt; quot;Captainquot; wrote:
gt; gt;
gt; gt; gt; How do I get a cell to show the day of the week when date entered.
gt; gt; gt; Example:A1 = 01/02/2005, A2 should Show Monday or MON.
gt; gt; gt; I have Excel 2000.
gt; gt;
gt; gt; Thanks! Is there a way to get the week # for a specific date?



quot;Ron Coderrequot; wrote:

gt; You'd think that was an easy question, right?
gt;
gt; Check Chip Pearson's website for the range of answers....
gt;
gt; www.cpearson.com/excel/weeknum.htm
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Captainquot; wrote:
gt; Thanks! Great web site!
Captain
gt; gt;
gt; gt;
gt; gt; quot;Captainquot; wrote:
gt; gt;
gt; gt; gt; How do I get a cell to show the day of the week when date entered.
gt; gt; gt; Example:A1 = 01/02/2005, A2 should Show Monday or MON.
gt; gt; gt; I have Excel 2000.
gt; gt;
gt; gt; Thanks! Is there a way to get the week # for a specific date?