Day of the Week - Is it possible to...

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a LONG column full of dates, about 15 years worth
of dates, in fact, formatted like so:

11/10/1987

I cannot find a function for it, but is there ANY WAY
POSSIBLE to return the actual Day of the Week for that
Date??...Is that a Monday, Tuesday, Wednesday, etc.?...Is
there a function that does this?...Life would be great if
there is...

Thanx...
 
Never mind...Figures, as soon as I ask the question, I
found the answer under:

Format
Cells
Number
Category
Custom
dddd

Sorry...But I am happy now!!!...
 
You could use the text function in another cell as well.

= TEXT (A1, "dddd")

Assuming that your date value is in cell A1.
 
You must log in or register to reply here.

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

CALENDAR CREATION 1
Excel Forecasting Dates Out to the Day 3
Day of Week and Date 14
Average of last 30 days 9
How capture a date variable within a text cell? 4
If C2 is Sunday how do I make D 2 to the next day of the week 2
Count Days 6
identifying the next working day after weekends and/or holidays 2

Back
Top