Question - Please read

L

lost

I don't know if Excel can do this or not. I have a date (ex: 12/24/2011) I
want Excel to take this date and tell me what day of the week it is (ex:
"Monday"). Any assistance would help.
 
C

Claus Busch

Am Fri, 15 Apr 2011 04:41:53 GMT schrieb [email protected]:
I don't know if Excel can do this or not. I have a date (ex: 12/24/2011) I
want Excel to take this date and tell me what day of the week it is (ex:
"Monday"). Any assistance would help.
Click to expand...

your date in A1. Then in B1:
=TEXT(A1,"dddd")


Regards
Claus Busch
 
D

Dave Peterson

You could give the cell/range a custom format that includes the date and day:

mm/dd/yyyy dddd
 
Top