show day in column B for Date in column A

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

[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,
Ron

[NYBoy]

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

You are The Best!!!
I could never figure this out..