| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check date
Hi,
How to code in VBA to find it is the 4th Sunday and 21st of the month or Last day of the month and 5th Sunday and is the Last day of the month falls on Sun? please advise. regards, Ben |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check date
Ben wrote:
How to code in VBA to find it is the 4th Sunday and 21st of the month or Last day of the month and 5th Sunday and is the Last day of the month falls on Sun? The 21st can't be the 4th Sunday. Maybe you're looking for the WeekDay function. ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==---------- http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check date
Hi Ben,
Take a look at First, Last, Nearest, Closest, nth weekday (4th Monday) in Month, Date calculations (#firstdate) http://www.mvps.org/dmcritchie/excel....htm#firstdate --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dave D-C" wrote in message ... Ben wrote: How to code in VBA to find it is the 4th Sunday and 21st of the month or Last day of the month and 5th Sunday and is the Last day of the month falls on Sun? The 21st can't be the 4th Sunday. Maybe you're looking for the WeekDay function. ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==---------- http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA check if date is in future | Excel Discussion (Misc queries) | |||
| check if a a date is in a specified daterange | Excel Worksheet Functions | |||
| Check input is a date | Excel Discussion (Misc queries) | |||
| how can i set a date reminder to check on something in a certain. | Excel Worksheet Functions | |||
| Check if date is a business day | Excel Discussion (Misc queries) | |||
Linear Mode
