DayofMonthbyWeek ( DayofWeekWanted_Sunday_1 ; WeekWantedasNum ; MonthasNum ; YearasNum )
Rate this function: Average rating: 3.5 (6 votes) Discuss this Custom Function
Yvonne Dutreaux, Cordblood Registry
http://www.cordblood.com
Find the weekday of a given month by week, ie: the 3rd Wednesday of the Month
Sample Input:
| DayofMonthbyWeek ( 3 ; 3 ; 3 ; 2009 ) |
|
Sample Output:
|
Description:
Find the weekday of a given month by week, ie: the 3rd Wednesday of the Month
The day and week are required, but the month and year will auto fill with the current day if not entered.
Good for finding days for meetings that are frequently on monthly basis on a specific day by week basis
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:
|
Newest Custom Functions:
| 1. |
Bin2Hex ( binary ) |
| |
(Sat, Mar 13, 10:08pm) |
| 2. |
SlideView (text) |
| |
(Sat, Mar 13, 8:40pm) |
| 3. |
HashFNV1a64 ( text ; empty ) |
| |
(Sat, Mar 13, 6:23pm) |
| 4. |
HashFNV1a32 ( text ; empty ) |
| |
(Sat, Mar 13, 5:55pm) |
| 5. |
XORbin( bin0 ; bin1 ; "" ) |
| |
(Sat, Mar 13, 4:35pm) |
| 6. |
cfMatch ( value_to_test; match_Value; match_operator ) |
| |
(Thu, Mar 11, 10:45pm) |
| 7. |
DeleteMiddleText ( Value ; StringStart ; StringEnd ) |
| |
(Wed, Mar 10, 8:27am) |
| 8. |
Codify( theText; code_option ) |
| |
(Sun, Mar 07, 8:17pm) |
 |
|