| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
Quote:
select Format, Cells, (Number) ,Custom and type ddd in the Type box. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| user defined function | Excel Worksheet Functions | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
