day/date correlation

johnT · Sep 11, 2003

is there a way to have a date in one cell ie: 9/11/03 and
have the adjacent cell specify the correct day ie:
thursday???

Dan E · Sep 11, 2003

John,

If you had the date in A1 put
=TEXT(A1,"dddd")
into B1 (or wherever you like)

Dan E

Jason Morin · Sep 11, 2003

A1: 9/11/03
B1: =A1

Custom format B1 as dddd.

HTH
Jason
Atlanta, GA