Day Of Week Formula

C

carl

If I have a date like 1/22/2005, is there a formula that can tell me what day
of the week that date is ?
 
T

Toppers

A1 contains your date ......

=CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
 
D

David Biddulph

carl said:
If I have a date like 1/22/2005, is there a formula that can tell me what
day
of the week that date is ?
Click to expand...

=TEXT(A1,"dddd")
or use the WEEKDAY() function to return a serial number for the day in the
week
 
P

Pete_UK

You could just format the cell using a custom format of dddd,
m/dd/yyyy.

Hope this helps.

Pete
 
Top