Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
date format and day of week
I downloaded a file into excel that has a column of dates (ex., 10/20/2007).
I then formatted this column to the same date format. My goal is to have a column that shows the corresponding day of week (ex., Saturday). In another cell (ex., C2), I entered "=B2" (the corresponding date) and did a custom format as "dddd". But when I hit "enter", it returns the original 10/20/2007. The kicker here is when I go into that cell and physically retype "10/20/2007", then cell C2 shows what I'm looking for (Saturday). I don't want to go in and retype all of the dates as there's many thousand. How do I fix? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
date format and day of week
Not the 'proper' way to do it (as there is still the fundamental problem),
but how about using =TEXT(B2,"dddd") -- __________________________________ HTH Bob "James" wrote in message ... I downloaded a file into excel that has a column of dates (ex., 10/20/2007). I then formatted this column to the same date format. My goal is to have a column that shows the corresponding day of week (ex., Saturday). In another cell (ex., C2), I entered "=B2" (the corresponding date) and did a custom format as "dddd". But when I hit "enter", it returns the original 10/20/2007. The kicker here is when I go into that cell and physically retype "10/20/2007", then cell C2 shows what I'm looking for (Saturday). I don't want to go in and retype all of the dates as there's many thousand. How do I fix? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format cells to show dates as the week-ending date of that | Excel Worksheet Functions | |||
Date format with day of week and date | Excel Discussion (Misc queries) | |||
How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) | |||
Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) |