| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
day of the week entry automatically
I have placed the date in one cell, but I need to enter the day of the week
automatically in another cell. Got a formula? |
|
#2
|
|||
|
|||
|
If the date is in A1 the formula in another cell is =A1 and format that cell
as Custom ddd or dddd Regards, Alan "DennyD" wrote in message ... I have placed the date in one cell, but I need to enter the day of the week automatically in another cell. Got a formula? |
|
#3
|
|||
|
|||
|
Sure. If the date is in A1, just put =A1 in the other cell. Then format the
cell to show the day instead of the date. The formula doesn't "show" the day, the formatting of the cell does. :) ************ Anne Troy www.OfficeArticles.com "DennyD" wrote in message ... I have placed the date in one cell, but I need to enter the day of the week automatically in another cell. Got a formula? |
|
#4
|
|||
|
|||
|
On Thu, 22 Sep 2005 11:56:18 -0700, DennyD
wrote: I have placed the date in one cell, but I need to enter the day of the week automatically in another cell. Got a formula? Or, as a formula: =TEXT(A1,"dddd") --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop automatically copying an entry to the next column? | Excel Discussion (Misc queries) | |||
| automatically change text case on entry | Excel Discussion (Misc queries) | |||
| user defined function | Excel Worksheet Functions | |||
| Date entry automatically | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Linear Mode
