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 (e-mail address removed):
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Modern equivalent of Autotext in Word? 0
Display weeks from a Milestone 0
Time Zone Conversion Table 1
Schedule Events 2
Allocate an income payment over a date range (tax years) 7
COnverting Weeks into Month (text data) 1
Copy previous record into form field 0

Top