Solved

determining the ordernal number of a certain week day.

Posted on 2001-07-23
8
297 Views
Last Modified: 2010-05-18
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
Comment
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
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 13

Accepted Solution

by:
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

by:theo kouwenhoven
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

by:bkpchs237
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 16

Expert Comment

by:theo kouwenhoven
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

by:Asta Cu
ID: 6467027
Is more needed?
Asta
0
 

Expert Comment

by:amp072397
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

by:amp072397
ID: 6719568
Awarding points to cri.

amp
community support moderator
0
 
LVL 13

Expert Comment

by:cri
ID: 6721663
amp, thank you.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article will show you how to use shortcut menus in the Access run-time environment.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question