show day in column B for Date in column A

N

NYBoy

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

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

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..
 
Top