monirg
Well-known Member
- Joined
- Jan 11, 2005
- Messages
- 629
<HR>
Note:
This is a re-post of my earlier Thread by the same Title (posted: Fri, July 08, 2011, ~ 3:30 PM EST.)
My Original Post and ALL replies had vanished from the Forum. I've notified the Admin, and can assure you it was NOT my fault!
I was about to try both the macro procedure and the w/s procedure, when I was advised that the Thread had been killed off by mistake by a rookie moderator on the Forum!
I'm doing my best here to remember the words and phrases I posted earlier, and I'd appreciate re-posting your earlier reply; if you still have it.
Thanks a lot.
<HR>
Hello;
My question may sound trivial to some, but it isn't really.
1) I need to identify the date of Friday of the 4th Week of a given month of a given year.
For example:
.... it is 23 for September, 2011
.... and it is 22 for October 2012.
2) I thought of creating a full 12-month calendar for each year of interest, and manually highlighting the date of Friday of the 4th week of each month.
I immediately realized that it would be messy and susceptible to errors!
3) I suppose one can create a smart macro to do just that, but more neatly:
... accepting a valid name for the month (i.e.; January to December)
... accepting a valid year (say; 2011 to 2021)
... and returning the date, something like:
..... "End of 4th Week: Friday, 28 September, 2012"
4) Alternatively, a w/s procedure using the Date functions, and no macros, may also do the trick:
... select the month & year from drop-down lists (say, starting C10 & D10 Sheet1)
... (month & year data validation ranges compiled on Sheet2)
... and the Date formula returns in cell C5 Sheet1 the date; something like:
..... "End of 4th Week: Friday, 26 October, 2012"
5) What if the above identified Friday is a Bank Holiday ??
... (may use a bogus holiday list for now)
... The w/s Date formula should instead return something like:
..... "End of 4th Week: Thursday, 25 October, 2012 (Friday is a Bank Holiday)"
... Does this add an unnecessary complication at this stage, and I should worry about it later ??
Can someone please provide some guidance on how-to, or provide a link to relevant macro / worksheet / Date formula, if already exist.
Thank you kindly.
Note:
This is a re-post of my earlier Thread by the same Title (posted: Fri, July 08, 2011, ~ 3:30 PM EST.)
My Original Post and ALL replies had vanished from the Forum. I've notified the Admin, and can assure you it was NOT my fault!
I was about to try both the macro procedure and the w/s procedure, when I was advised that the Thread had been killed off by mistake by a rookie moderator on the Forum!
I'm doing my best here to remember the words and phrases I posted earlier, and I'd appreciate re-posting your earlier reply; if you still have it.
Thanks a lot.
<HR>
Hello;
My question may sound trivial to some, but it isn't really.
1) I need to identify the date of Friday of the 4th Week of a given month of a given year.
For example:
.... it is 23 for September, 2011
.... and it is 22 for October 2012.
2) I thought of creating a full 12-month calendar for each year of interest, and manually highlighting the date of Friday of the 4th week of each month.
I immediately realized that it would be messy and susceptible to errors!
3) I suppose one can create a smart macro to do just that, but more neatly:
... accepting a valid name for the month (i.e.; January to December)
... accepting a valid year (say; 2011 to 2021)
... and returning the date, something like:
..... "End of 4th Week: Friday, 28 September, 2012"
4) Alternatively, a w/s procedure using the Date functions, and no macros, may also do the trick:
... select the month & year from drop-down lists (say, starting C10 & D10 Sheet1)
... (month & year data validation ranges compiled on Sheet2)
... and the Date formula returns in cell C5 Sheet1 the date; something like:
..... "End of 4th Week: Friday, 26 October, 2012"
5) What if the above identified Friday is a Bank Holiday ??
... (may use a bogus holiday list for now)
... The w/s Date formula should instead return something like:
..... "End of 4th Week: Thursday, 25 October, 2012 (Friday is a Bank Holiday)"
... Does this add an unnecessary complication at this stage, and I should worry about it later ??
Can someone please provide some guidance on how-to, or provide a link to relevant macro / worksheet / Date formula, if already exist.
Thank you kindly.
ffice
></o
