|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#11
April 24th, 2006, 09:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1st Monday of a month in date range??
Example: How many 5th Fridays are between 5/1/2006 and 6/30/2006 The answer should be 1, your formula works if I change the end date to 7/1/2006 but not for 6/30/2006 which I need and would love. It is more for a date range where the begin and end date could fall on days other than the first of the month. Thanks again, cheers -- scwilly ------------------------------------------------------------------------ scwilly's Profile: http://www.excelforum.com/member.php...o&userid=18251 View this thread: http://www.excelforum.com/showthread...hreadid=535648 
|
|
#12
April 24th, 2006, 11:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
1st Monday of a month in date range??
scwilly: The end date problem might be easily solved by changing the formula to ensure that the end date is the 1st of the next month. I'm still unclear about the start date. What are some non-first-of-the-month scenarios and what values would you expect. From your previous posts I infer that this situation might arise: StartDate: 1/21/2006 EndDate: 4/19/2006 Occurrences: 4 WeekDay: TUE What count would you expect and why? Or is that not a valid scenario? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=535648
|
|
#13
April 24th, 2006, 11:59 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
1st Monday of a month in date range??
Thank GOD you are still around. I am trying to change the start and stop dates so that in the formula they don't always have to be the first of the months. I looked at the datedif function I don't know how to change it so that I don't have to use e.g. 1/1/2006, 3/1/2006 etc. -- scwilly ------------------------------------------------------------------------ scwilly's Profile: http://www.excelforum.com/member.php...o&userid=18251 View this thread: http://www.excelforum.com/showthread...hreadid=535648
|
|
#14
April 25th, 2006, 12:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
1st Monday of a month in date range??
Thank GOD you are still around. I am trying to change the start and stop dates so that in the formula they don't always have to be the first of the months. I looked at the datedif function I don't know how to change it so that I don't have to use e.g. 1/1/2006, 3/1/2006 etc. -- scwilly ------------------------------------------------------------------------ scwilly's Profile: http://www.excelforum.com/member.php...o&userid=18251 View this thread: http://www.excelforum.com/showthread...hreadid=535648
|
|
#15
April 25th, 2006, 12:01 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
1st Monday of a month in date range??
Thank GOD you are still around. I am trying to change the start and stop dates so that in the formula they don't always have to be the first of the months. I looked at the datedif function I don't know how to change it so that I don't have to use e.g. 1/1/2006, 3/1/2006 etc. -- scwilly ------------------------------------------------------------------------ scwilly's Profile: http://www.excelforum.com/member.php...o&userid=18251 View this thread: http://www.excelforum.com/showthread...hreadid=535648
|
|
#16
April 25th, 2006, 12:09 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
1st Monday of a month in date range??
Now that you know I'm thankful you are still around the scenario you outlined IS what I'm looking for. I would expect to get 4 thursdays for that range and occurence. Now how can we change your formula to account for the range you gave me an example for? -- scwilly ------------------------------------------------------------------------ scwilly's Profile: http://www.excelforum.com/member.php...o&userid=18251 View this thread: http://www.excelforum.com/showthread...hreadid=535648
|
|
#17
April 25th, 2006, 01:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
1st Monday of a month in date range??
scwilly: Possibly my last question... In the example scenario: StartDate: 1/21/2006 EndDate: 4/19/2006 Occurrences: 4 WeekDay: TUE You indicated that there would be four 4th-Tuesdays. I'm guessing that those four 4th-Tuesdays would be: Jan_24th Feg_28th Mar_28th Apr_25th If that's true, do you mean that we should use the entire month of the StartDate and entire month of the EndDate? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=535648
|
|
#18
April 25th, 2006, 01:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
1st Monday of a month in date range??
scwilly: Possibly my last question... In the example scenario: StartDate: 1/21/2006 EndDate: 4/19/2006 Occurrences: 4 WeekDay: TUE You indicated that there would be four 4th-Tuesdays. I'm guessing that those four 4th-Tuesdays would be: Jan_24th Feg_28th Mar_28th Apr_25th If that's true, do you mean that we should use the entire month of the StartDate and entire month of the EndDate? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=535648
|
|
#19
April 25th, 2006, 01:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
1st Monday of a month in date range??
scwilly: Possibly my last question... In the example scenario: StartDate: 1/21/2006 EndDate: 4/19/2006 Occurrences: 4 WeekDay: TUE You indicated that there would be four 4th-Tuesdays. I'm guessing that those four 4th-Tuesdays would be: Jan_24th Feg_28th Mar_28th Apr_25th If that's true, do you mean that we should use the entire month of the StartDate and entire month of the EndDate? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=535648
|
|
#20
April 25th, 2006, 11:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
1st Monday of a month in date range??
Apologies, MS Newsgroupers
For some unknown reason, one click on the ExcelTip forum posting link results in 3 posts to the newsgroup. Annoying. *********** Regards, Ron XL2002, WinXP-Pro "Ron Coderre" wrote: scwilly: Possibly my last question... In the example scenario: StartDate: 1/21/2006 EndDate: 4/19/2006 Occurrences: 4 WeekDay: TUE You indicated that there would be four 4th-Tuesdays. I'm guessing that those four 4th-Tuesdays would be: Jan_24th Feg_28th Mar_28th Apr_25th If that's true, do you mean that we should use the entire month of the StartDate and entire month of the EndDate? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=535648
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Finding the date on the 'nth' Monday in this Month in this Year | agarwaldvk | Worksheet Functions | 1 | April 17th, 2006 10:53 PM |
| How do you sort a date range by month? | Brewisc13 | General Discussion | 13 | July 7th, 2005 06:45 PM |
| Date Range and Average F/X Rate | David | General Discussion | 0 | June 23rd, 2005 02:26 PM |
| Date of Month vs. Now | Walter Steadman | Running & Setting Up Queries | 10 | June 9th, 2005 09:50 PM |
| Count the occurances of a month in a range of date fields | Keith Brown | Worksheet Functions | 8 | March 14th, 2005 11:24 AM |
Linear Mode
