Determine day of week in text format

[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

 

[John C]

=TEXT(A1,"dddd")

 

[Mike H]

or

=A1

Formatted as dddd

Mike

 

[Domenic]

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!

 

[WLMPilot]

Thanks!

=TEXT(A1,"dddd")

 

[WLMPilot]

Thanks!

or

=A1

Formatted as dddd

Mike

 

[WLMPilot]

Thanks!

Try...

=TEXT(A1,"dddd")

Hope this helps!