| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to display day in text format
I need a formula that will display the day (i.e. Sunday, Monday, etc..) based on a date in another cell (i.e. B2). Thanks in advance -- Weasel ------------------------------------------------------------------------ Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206 View this thread: http://www.excelforum.com/showthread...hreadid=511847 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to display day in text format
=TEXT(B2,"dddd")
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Weasel" wrote in message ... I need a formula that will display the day (i.e. Sunday, Monday, etc..) based on a date in another cell (i.e. B2). Thanks in advance -- Weasel ------------------------------------------------------------------------ Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206 View this thread: http://www.excelforum.com/showthread...hreadid=511847 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to display day in text format
Two other methods...pick your preference.
Use custom formating (Format Cells Custom enter dddd in the custom window =CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu", "Fri","Sat") - John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Format Number to Text | Excel Worksheet Functions | |||
| TEXT function to format a date in English & French | Excel Worksheet Functions | |||
Linear Mode
