If the date reads 02/01/2013 Is there a command that returns the day of the week
i.e Wednesday
Many Thanks
Depends on how you want to display the Day. You can use a Regular Date Format,
on my 2007 the second choice under Date
will display the Date as: Wednesday, January 02, 2013If all you want is just the Day of Week, then a Custom Format of
DDD = Wed
while
DDDD = WednesdayThere are other ways if these are not suitable.
Many thanks for coming back so quick E1 = 02/01/2013
How can I make it return Wednesday in E2
I havent got excel 2007
Look up the WEEKDAY function in Excel help. You should be able to use something like this:
=CHOOSE(WEEKDAY(E1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
In cell E2 use a the Custom Format
On the Task Bar
Select Format
Click Cells.
On the Number tab,
Click Custom, it is at the bottom of the Category listOn the right side, in the input box below the word Type,
delete whatever is in the box and enter: DDDDClick OK
Now in cell E2 enter the formula: =E1
You should get your day of the week in cell E2
I'm not sure whose response you are bemused about, so I'll explain both. Mike's:
Mike is suggesting that you format the cell with the custom format DDDD which will display any date as just the Day name. There are lots of Custom formats that can be used and it would be impossible to list them all. Many can be found via a Google search for the format you are looking for such as "custom cell format for day of week"
Mine:
The WEEKDAY function returns a number that represents the day of the week. 1,2,3, etc. Depending on which return_value argument you use the number for a given date will be different. The Excel Help files explain the use of the return_value argument.
The CHOOSE function uses a number to return a value from a list included as the arguments for the function. Once again, the Excel Help files explain how the function works in more detail.
By combining the 2 functions, the WEEKDAY function will return the number for the CHOOSE function to use.
Try each function separately to see how they work and read the Help files. That should help you understand how the combination works.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Another way that I use a lot especially when I want a text result is E2=TEXT(E1,"DDDD")
This will return "Wednesday"
Using cell formatting or the TEXT function works great if you are looking for a "built-in" value to be returned. "ddd" = Wed
"dddd" = WednesdayFor customized choices, the CHOOSE(WEEKDAY(... method can be useful:
=CHOOSE(WEEKDAY(E1),"Sonntag","Montag", "Dienstag","Mittwoch","Donnerstag","Freitag","Samstag")
The CHOOSE(WEEKDAY(... method can also be used to force weekend dates to be weekday day names if required for business purposes.
=CHOOSE(WEEKDAY(E1),"Monday","Monday","Tuesday","Wednesday","Thursday","Friday","Friday")
All three methods are great suggestions.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.