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

Asked By Corey Joel 0 points N/A Posted on - 12/06/2014

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?

 

• Status: Open
• Question Views: 1165
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Irish Gail

Go To Solution

Best Answer

Best Answer

Answered By Irish Gail 0 points N/A #200160

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

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. 

About Irish Gail

Questions
0

Answers
8

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 12/16/2014
• Question Category: MS Excel

Answered By Kenry Fal 0 points N/A #200161

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

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!!!!

About Kenry Fal

Questions
0

Answers
99

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 01/16/2015
• Question Category: MS Excel