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 =-----