Solved Returning The day of the week

January 2, 2013 at 04:00:38
Specs: Windows 7
If the date reads 02/01/2013

Is there a command that returns the day of the week

i.e Wednesday

Many Thanks


See More: Returning The day of the week

Report •


#1
January 2, 2013 at 04:06:14
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, 2013

If all you want is just the Day of Week, then a Custom Format of
DDD = Wed
while
DDDD = Wednesday

There are other ways if these are not suitable.

MIKE

http://www.skeptic.com/


Report •

#2
January 2, 2013 at 04:13:51
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


Report •

#3
January 2, 2013 at 04:45:39
✔ Best Answer
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.


Report •

Related Solutions

#4
January 2, 2013 at 04:52:01
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 list

On the right side, in the input box below the word Type,
delete whatever is in the box and enter: DDDD

Click OK

Now in cell E2 enter the formula: =E1

You should get your day of the week in cell E2

MIKE

http://www.skeptic.com/


Report •

#5
January 2, 2013 at 05:02:05
Thanks works spot on

Report •

#6
January 2, 2013 at 05:03:50
How why does that work bemused Lol

Thanks


Report •

#7
January 2, 2013 at 06:34:27
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.


Report •

#8
January 2, 2013 at 08:27:01
Thanks thats very helpful

Report •

#9
January 2, 2013 at 10:34:38
Another way that I use a lot especially when I want a text result is

E2=TEXT(E1,"DDDD")

This will return "Wednesday"


Report •

#10
January 2, 2013 at 11:18:17
Using cell formatting or the TEXT function works great if you are looking for a "built-in" value to be returned.

"ddd" = Wed
"dddd" = Wednesday

For 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.


Report •


Ask Question