| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to return day in the form "Monday", "Tuesday" etc given .
Hello. What function in excel will return the day in the form "Monday",
"Tuesday" et given a date. Or, if it has to be by cell formatting, how do I do it? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function to return day in the form "Monday", "Tuesday" etc given .
Hi,
In the cell where you want your day of the week type =TEXT(A2, "dddd") Change cell reference A2 to suit... Regards, Gav. "MTro" wrote: Hello. What function in excel will return the day in the form "Monday", "Tuesday" et given a date. Or, if it has to be by cell formatting, how do I do it? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function to return day in the form "Monday", "Tuesday" etc given .
You can also select the cells where you are entering the dates and set a
custom format by... FormatCellsNumber tabUnder category select custom and in the type box enter dddd. Now when you enter a date in the cells the correct day will be displayed.. Regards, Gav. "MTro" wrote: Hello. What function in excel will return the day in the form "Monday", "Tuesday" et given a date. Or, if it has to be by cell formatting, how do I do it? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| if "x" days is more fall on weekend return following monday | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
