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? |
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? |
All times are GMT +1. The time now is 01:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com