How to find out day with respect to date in other column

[shaileshgavanang]

Hi,

i have date in one column and day in other column.

i want to find out day automaticaly if i enter date in other.

sample xls attached.

thank you,

[SteveG]

Hi,

In B6:

=CHOOSE(WEEKDAY(A6),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

Copy down as needed.

HTH
Steve

[Søren Larsen]

Try this in B6:

=TEXT(WEEKDAY(A6),"dddd") and copy down.?

[SteveG]

Forgot about Loren's solution. Much less to type

Steve

[shaileshgavanang]

Hi all,

thank all above solutions are working.

thanks for your swift reply

[martindwilson]

just put =a6 in b6 and format cell DDDD