| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine day of week in text format
I have a date "mm/dd/yy" in A1. How do I determine the day in text format
for B1, ie Sunday, Monday, etc. Thanks, Les |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Determine day of week in text format
=TEXT(A1,"dddd")
-- John C "WLMPilot" wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Determine day of week in text format
or
=A1 Formatted as dddd Mike "WLMPilot" wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Determine day of week in text format
In article ,
WLMPilot wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les Try... =TEXT(A1,"dddd") Hope this helps! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Determine day of week in text format
Thanks!
"John C" wrote: =TEXT(A1,"dddd") -- John C "WLMPilot" wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Determine day of week in text format
Thanks!
"Mike H" wrote: or =A1 Formatted as dddd Mike "WLMPilot" wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Determine day of week in text format
Thanks!
"Domenic" wrote: In article , WLMPilot wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les Try... =TEXT(A1,"dddd") Hope this helps! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| date format and day of week | Setting up and Configuration of Excel | |||
| Formula to determine number of current records by week | Excel Worksheet Functions | |||
| Determine day of the week from date | Excel Discussion (Misc queries) | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) | |||
Linear Mode
