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.
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.
-u
=TEXT(A4,"ddd")
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Perfect. Thanks xld.
-u
Posting Permissions
Reply With Quote
