Determine day of week in text format

W

WLMPilot

I have a date "mm/dd/yy" in A1. How do I determine the day in text format
for B1, ie Sunday, Monday, etc.

Thanks,
Les
 
D

Domenic

WLMPilot said:
I have a date "mm/dd/yy" in A1. How do I determine the day in text format
for B1, ie Sunday, Monday, etc.

Thanks,
Les

Try...

=TEXT(A1,"dddd")

Hope this helps!
 
Top