Is there a formula which will tell me what day of the week a certain fell on?
C Cindy Smith Jan 12, 2006 #1 Is there a formula which will tell me what day of the week a certain fell on?
D David Billigmeier Jan 12, 2006 #2 <Format><Cells> Go to the "Number" tab Click on "Custom" Enter "dddd" (without the quotes)
S Sloth Jan 12, 2006 #3 =WEEKDAY(A1) outputs the day number (1-7) of the week. If you need the name of the day (Sun-Sat), then use a custom number format of dddd or, use this formula and format as general =TEXT(WEEKDAY(A1),"dddd")
=WEEKDAY(A1) outputs the day number (1-7) of the week. If you need the name of the day (Sun-Sat), then use a custom number format of dddd or, use this formula and format as general =TEXT(WEEKDAY(A1),"dddd")
