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 ?

Look at WEEKDAY function.

"carl" wrote:

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 ?

A1 contains your date ......

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

"Toppers" wrote:

Look at WEEKDAY function.

"carl" wrote:

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 ?

"carl" wrote in message
...
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 ?

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

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

Hope this helps.

Pete