| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Day of the Week - Is it possible to...
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... |
|
#2
|
|||
|
|||
|
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!!!... -----Original Message----- 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... . |
|
#3
|
|||
|
|||
|
You could use the text function in another cell as well.
= TEXT (A1, "dddd") Assuming that your date value is in cell A1. "Steve" wrote in message ... 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!!!... -----Original Message----- 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... . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
| how to get week number in month in excel ? | Charts and Charting in Excel | |||
| Weeknum Year by Year Compare | Charts and Charting in Excel | |||
| Day of the week | Excel Discussion (Misc queries) | |||
| How can I create formula that turns a date into the week # in | Excel Discussion (Misc queries) | |||
Hybrid Mode
