How do I get a cell to show the day of the week when date entered
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. |
How do I get a cell to show the day of the week when date entered
Try this:
Select the cell(s) that are impacted FormatCellsNumber tab Category: Custom Type: ddd Returns: Mon, Tue, etc Type: dddd Returns: Monday, Tuesday, etc Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Captain" wrote: 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. |
Quote:
select Format, Cells, (Number) ,Custom and type ddd in the Type box. |
How do I get a cell to show the day of the week when date entered
Hi Captn'
Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005 HTH Regards, Howard "Captain" wrote in message ... 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. |
How do I get a cell to show the day of the week when date entered
"Captain" wrote: 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. Thanks! Is there a way to get the week # for a specific date? |
How do I get a cell to show the day of the week when date ente
You'd think that was an easy question, right?
Check Chip Pearson's website for the range of answers.... http://www.cpearson.com/excel/weeknum.htm Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Captain" wrote: "Captain" wrote: 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. Thanks! Is there a way to get the week # for a specific date? |
How do I get a cell to show the day of the week when date ente
"L. Howard Kittle" wrote: Hi Captn' Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005 HTH Regards, Howard "Captain" wrote in message ... 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. Thanks! How do I get a cell to show the Week Number for specific dates? Thanks again Captain |
How do I get a cell to show the day of the week when date entered
Unless the Captain is English, then it would return TUE
<bg -- Regards, Peo Sjoblom (No private emails please) "L. Howard Kittle" wrote in message ... Hi Captn' Try =TEXT(A1,"ddd") which will return SUN, not MON for 1/2/2005 HTH Regards, Howard "Captain" wrote in message ... 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. |
How do I get a cell to show the day of the week when date ente
"Ron Coderre" wrote: You'd think that was an easy question, right? Check Chip Pearson's website for the range of answers.... http://www.cpearson.com/excel/weeknum.htm Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Captain" wrote: "Captain" wrote: 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. Thanks! Is there a way to get the week # for a specific date? |
How do I get a cell to show the day of the week when date ente
"Ron Coderre" wrote: You'd think that was an easy question, right? Check Chip Pearson's website for the range of answers.... http://www.cpearson.com/excel/weeknum.htm Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Captain" wrote: Thanks! Great web site! Captain "Captain" wrote: 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. Thanks! Is there a way to get the week # for a specific date? |
All times are GMT +1. The time now is 08:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com