Can Excel to tell me which day of the week it is

Asked By 0 points N/A Posted on -
qa-featured
I need to use the WEEKDAY function in Excel for my work. When I use the function it gives me an integer value from 1 to 7.Should it not be telling me which day of the week I am looking up? How can I make the function do that? Is there any other function that I could use for this instead?

 

SHARE
Best Answer by Irish Gail
Best Answer
Best Answer
Answered By 0 points N/A #200160

Can Excel to tell me which day of the week it is

qa-featured

Hi Corey! 

I had similar problem a few weeks ago and came up with two possible ways to do this.

One way to do this is is using this formula, but you need to use referencing cells. It doesn’t look very nice but it is easy to remember and an effective way to doo this.

In cell A2 enter the date.

Than you need to set up an another cell, let’s say A3 containing formula that references cell A2: =WEEKDAY(A2,1)

In this case A2 is the date cell and number 1 is the return type (1 is Sunday, 2 is Monday, 3 is Tuesday, 4 is Wednesday, 5 is Thursday, 6 is Friday and 7 is Saturday). This way, as I am sure you already know, you get for example number 6 for 8/31/2001. Now you need those numbers to be the days names. So you need to enter following formula to  new cell lets say cell A4. Here you enter the formula:

=IF(A3=1,"Sunday",IF(A3=2,"Monday",IF(A3=3,"Tuesday", IF(A3=4,"Wednesday", IF(A3=5,"Thursday" IF(A3=6,"Friday" IF(A3=7,"Saturday")))))))

Or you can do it with one formula:

=CHOOSE(WEEKDAY(A3),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

In this formula if you need for day 1 to be perhaps Monday, you just change the order of the days. 

Answered By 0 points N/A #200161

Can Excel to tell me which day of the week it is

qa-featured

Hello Corey Joel,     yes excel tells you which day it is and of which week. Procedure is explained below:-

»==== Select the cells that contain dates that you want to show as the days of the week.

»==== go the Home tab– Number group–click on arrow—click More Number Formats– click the Number tab.

»====   Category—click Custom—Type box—- type dddd for the full name of the day of the week (Monday, Tuesday, and so on), or ddd for the abbreviated name of the day of the week (Mon, Tue, Wed, and so on).

 That's all!!!!

Login/Register to Answer

Related Questions