Day formatting

J

JE McGimpsey

One way:


A1: 11/05/1995
B1: =A1

Format B1 with

Format/Cells/Number/Custom dddd

to display Sunday

alternatively, use a worksheet function:

B1: =TEXT(A1, "dddd")
 
Top