N NYBoy Apr 5, 2006 #1 I want the Excel to show the day of the week in column B for whatever date is entered in column A. Please advise.
I want the Excel to show the day of the week in column B for whatever date is entered in column A. Please advise.
R Ron Coderre Apr 5, 2006 #2 Here are 2 options: For a date in A1 B1: =TEXT(A1,"DDD") OR B1: =A1 Custom Format B1 to only show the day <Format><Cells><Number tab> Category: Custom Type: DDD Note: DDD shows the 3 letter day (Mon, Tue, etc) DDDD shows the full day name (Monday, Tuesday, etc) Does that help? Regards, Ro
Here are 2 options: For a date in A1 B1: =TEXT(A1,"DDD") OR B1: =A1 Custom Format B1 to only show the day <Format><Cells><Number tab> Category: Custom Type: DDD Note: DDD shows the 3 letter day (Mon, Tue, etc) DDDD shows the full day name (Monday, Tuesday, etc) Does that help? Regards, Ro
N NYBoy Apr 5, 2006 #3 Ron said: Here are 2 options: For a date in A1 B1: =TEXT(A1,"DDD") OR B1: =A1 Custom Format B1 to only show the day <Format><Cells><Number tab> Category: Custom Type: DDD Note: DDD shows the 3 letter day (Mon, Tue, etc) DDDD shows the full day name (Monday, Tuesday, etc) Does that help? Regards, Ron Click to expand... You are The Best!!! I could never figure this out..
Ron said: Here are 2 options: For a date in A1 B1: =TEXT(A1,"DDD") OR B1: =A1 Custom Format B1 to only show the day <Format><Cells><Number tab> Category: Custom Type: DDD Note: DDD shows the 3 letter day (Mon, Tue, etc) DDDD shows the full day name (Monday, Tuesday, etc) Does that help? Regards, Ron Click to expand... You are The Best!!! I could never figure this out..
