Thread
:
Determine day of week in text format
View Single Post
#
7
Posted to microsoft.public.excel.misc
WLMPilot
external usenet poster
Posts: 470
Determine day of week in text format
Thanks!
"Domenic" wrote:
In article ,
WLMPilot wrote:
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!
Reply With Quote
WLMPilot
View Public Profile
Find all posts by WLMPilot