Solved

# determining the ordernal number of a certain week day.

Posted on 2001-07-23
303 Views
How can I determining the ordernal number of a certain week day?

I mean, funtion(today()) should return 4. because today(7.23) is the 4th monday of this month.

and the number should be set unless a user saves.

Thanks.
0
Question by:iamjhkang
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2
• 2
• 2
• +2

LVL 13

Accepted Solution

cri earned 50 total points
ID: 6307651
Use WEEKDAY(serial_number,return_type)

See Excel Help regarding 'return_type' which defines the start of the week.
0

LVL 16

Expert Comment

ID: 6307745
To get the right day name with the weekday function, you can include it in an index function:

example:

=INDEX({"So","Mo","Tu","We","Th","Fr","Za"},1,WEEKDAY(TODAY()))

GL
0

LVL 6

Expert Comment

ID: 6350781
jamjhkang,

If I understand your request correctly you want to know if a certain date is the first, second, third, fourth or fifth of a particular weekday of the month.  The following formula will accomplish the task.  However, you will need to activate the Analysis ToolPak thru the Tools, Add-ins menu option.

=IF(WEEKDAY(B1)=WEEKDAY(EOMONTH(B1,-1)),INT((B1-EOMONTH(B1,-1))/7),INT((B1-EOMONTH(B1,-1))/7)+1)

where B1 is the cell that you entered the date you want to analyze.

Hope this helps.
0

LVL 16

Expert Comment

ID: 6351240
What do you mean by "because today(7.23) is the 4th monday of this month"

Do you like to have:
- Daynumber of the week,
- Daynumber of the month
- Daynumber of the year
- Weeknumber of the month
- Weeknumber of the year.
- Month number of the year

Tell me, looking at the given comments, it's not very clear.

0

LVL 27

Expert Comment

ID: 6467027
Is more needed?
Asta
0

Expert Comment

ID: 6706550
iamjhkang, how are you?

I know the email notifications were working erratically at best before, but they work great now. If you don't respond within 7 days, I'll be awarding points to cri. Other answers may be valid, but he posted first.

amp
Community Support Moderator
0

Expert Comment

ID: 6719568
Awarding points to cri.

amp
community support moderator
0

LVL 13

Expert Comment

ID: 6721663
amp, thank you.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me â€¦