Return day of the Week from a Date

Posted by Craig D on May 23, 2000 6:07 AM

How do I return the day of the week from a date in a cell. I can get the numeric value by using =weekday(A1) where Cell A1 has a format of 5/23/00 but I'm can't figure out how to get it to tell me that its a Tuesday

Thanks for the help

Posted by Brett on May 23, 2000 7:03 AM

Use:
=TEXT(A1, "dddd")

Posted by Craid D on May 23, 2000 8:55 AM

Brett
Thanks a million This did the trick!