| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FUNCTION TO RETURN "DAY OF THE WEEK"
I want a function to return the day of the week in text not integer (ie
"Tuesday"). I've tried the TODAY and WEEKDAY functions but must be doing something wrong. Can you help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FUNCTION TO RETURN "DAY OF THE WEEK"
=TODAY()
click format/cells/custom Type: dddd "Jo" wrote: I want a function to return the day of the week in text not integer (ie "Tuesday"). I've tried the TODAY and WEEKDAY functions but must be doing something wrong. Can you help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FUNCTION TO RETURN "DAY OF THE WEEK"
or you could use:
=TEXT(TODAY(), "dddd") your choice depends on whether you want the contents of the cell to be text or numeric (my first suggestion). "Jo" wrote: I want a function to return the day of the week in text not integer (ie "Tuesday"). I've tried the TODAY and WEEKDAY functions but must be doing something wrong. Can you help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FUNCTION TO RETURN "DAY OF THE WEEK"
3/3/2008 in A1
In B1 enter =WEEKDAY(A1) will return the number 2 Format as Custom dddd to see Monday Gord Dibben MS Excel MVP On Mon, 3 Mar 2008 17:25:01 -0800, Jo wrote: I want a function to return the day of the week in text not integer (ie "Tuesday"). I've tried the TODAY and WEEKDAY functions but must be doing something wrong. Can you help? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FUNCTION TO RETURN "DAY OF THE WEEK"
SPOT ON - thanks
"JMB" wrote: =TODAY() click format/cells/custom Type: dddd "Jo" wrote: I want a function to return the day of the week in text not integer (ie "Tuesday"). I've tried the TODAY and WEEKDAY functions but must be doing something wrong. Can you help? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
FUNCTION TO RETURN "DAY OF THE WEEK"
quite welcome - thanks for the feedback
"Jo" wrote: SPOT ON - thanks "JMB" wrote: =TODAY() click format/cells/custom Type: dddd "Jo" wrote: I want a function to return the day of the week in text not integer (ie "Tuesday"). I've tried the TODAY and WEEKDAY functions but must be doing something wrong. Can you help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
| "No RETURN() or HALT() function found on macro sheet." | Excel Worksheet Functions | |||
| get the VLOOKUP function to return the "contents" of a cell? | Excel Worksheet Functions | |||
Linear Mode
