PDA

View Full Version : Solved: Return DAY of Week based on Date



U_Shrestha
07-13-2008, 01:31 PM
Hi all,

Range A4:A contains date in MM/DD/YY format; in range B4:B, I would like to see its corresponding day of the week. For example, if A4 has 7/13/08, then in B4, I want to see "Sun" (just 3-letters). Can someone please help? Thanks.

Bob Phillips
07-13-2008, 01:42 PM
=TEXT(A4,"ddd")

U_Shrestha
07-13-2008, 02:10 PM
Perfect. Thanks xld.