# Matching date with days

1. ## Matching date with days

Is there any formula to match dates with the days in excel.
e.g if my date is 25-jan-12 on cell A1 and i wish to return the day of the week on cell B1, what formula can be used?

2. ## Re: Matching date with days

Depends what you mean by day of the week. There is a WEEKDAY function, or, if you just mean Monday, Tuesday, etc, you could use formatting on a copy of the cell.

Regards, TMS

3. ## Re: Matching date with days

=TEXT(WEEKDAY(A1),"dddd")

- Moo

4. ## Re: Matching date with days

@Moo: that would probably DAY not WEEKDAY but, if it's just for display, you can do that with formatting.

Regards, TMS

5. ## Re: Matching date with days

It worked perfectly guys! thanks alot

6. ## Re: Matching date with days

You're welcome.

New quick method:

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

7. ## Re: Matching date with days

Just to clarify some of the options:

HTML Code:
``````Value		Formula			Format			Type			General

28/11/2012	=TODAY()

28		=A1			format "dd"		numeric			41241

Wed		=A1			format "ddd"		(numeric)		41241

Wednesday	=A1			format "dddd"		(numeric)		41241

28		=TEXT(A1,"dd")					text (left aligned)	28

28		=DAY(A1)					numeric			28

28		=TEXT(DAY(A1),"00")				text (left aligned)	28

4		=WEEKDAY(A1)								4

4		=WEEKDAY(A1,1)								4

3		=WEEKDAY(A1,2)								3

2		=WEEKDAY(A1,3)								2``````

WEEKDAY is the day of the week. It has a second parameter which determines which day you start counting with;

1 or omitted Numbers 1 (Sunday) through 7 (Saturday). Behaves like previous versions of Microsoft Excel.
2 Numbers 1 (Monday) through 7 (Sunday).
3 Numbers 0 (Monday) through 6 (Sunday).

I probably confused the issue when I replied to Moo as using TEXT would require the second parameter to be "00" not "dd".

Regards, TMS

8. ## Re: Matching date with days

Thanks, Trevor. Appreciate the clarification.
- Moo

9. ## Re: Matching date with days

@Moo: You're welcome. Thanks for the rep.

10. ## Re: Matching date with days

@TMS Thanks for a detail u sent me for the thread. I'm trying to apply it. i hope i succeed

11. ## Re: Matching date with days

You're welcome. Thanks for the rep.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1