| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to convert date to day
I am trying to convert a date, column A(ie 01/16/2006), to the day of the
month, column B, that this date format represents. column column A B 01/16/2006 Thursday Is this possible or am I in another demention. -- icky |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to convert date to day
Nope, you aren't in another dimension. If you just want the day displayed,
you can use this formula: =LOOKUP(WEEKDAY(A1),{1,2,3,4,5,6,7},{"Sunday","Mon day","Tuesday","Wednesday","Thursday","Friday","Sa turday"}) There may be an easier way, but this works. "icky" wrote: I am trying to convert a date, column A(ie 01/16/2006), to the day of the month, column B, that this date format represents. column column A B 01/16/2006 Thursday Is this possible or am I in another demention. -- icky |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to convert date to day
=text(a1,"dddd")
But I think I'd use a custom format in column A: mm/dd/yyyy* dddd And widen the column. icky wrote: I am trying to convert a date, column A(ie 01/16/2006), to the day of the month, column B, that this date format represents. column column A B 01/16/2006 Thursday Is this possible or am I in another demention. -- icky -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to convert date to day
Barb,
It worked great. Thank you very much. -- icky "Barb Reinhardt" wrote: Nope, you aren't in another dimension. If you just want the day displayed, you can use this formula: =LOOKUP(WEEKDAY(A1),{1,2,3,4,5,6,7},{"Sunday","Mon day","Tuesday","Wednesday","Thursday","Friday","Sa turday"}) There may be an easier way, but this works. "icky" wrote: I am trying to convert a date, column A(ie 01/16/2006), to the day of the month, column B, that this date format represents. column column A B 01/16/2006 Thursday Is this possible or am I in another demention. -- icky |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to convert date to day
Dave,
Your function formula also worked. Thanks for the help. -- icky "Dave Peterson" wrote: =text(a1,"dddd") But I think I'd use a custom format in column A: mm/dd/yyyy* dddd And widen the column. icky wrote: I am trying to convert a date, column A(ie 01/16/2006), to the day of the month, column B, that this date format represents. column column A B 01/16/2006 Thursday Is this possible or am I in another demention. -- icky -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Trying to convert date to day
Dave,
If someone were to use a Pivot Table to evaluate this data, would it work or not? I'm thinking NOT. Thanks, Barb "Dave Peterson" wrote: =text(a1,"dddd") But I think I'd use a custom format in column A: mm/dd/yyyy* dddd And widen the column. icky wrote: I am trying to convert a date, column A(ie 01/16/2006), to the day of the month, column B, that this date format represents. column column A B 01/16/2006 Thursday Is this possible or am I in another demention. -- icky -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert date format | Excel Discussion (Misc queries) | |||
| How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only? | Excel Worksheet Functions | |||
| How do I convert a text string into a date? | Excel Worksheet Functions | |||
| Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
| Is there a macro to convert times between 2 places dep. on date? | Excel Worksheet Functions | |||
Linear Mode
