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
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#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 |