VBA code for getting the third monday for each month

[Archies]

Hi,I want to write a VBA code that will find the third monday every month and will add one sheet in my excel.I have a code that adds a sheet to excel but not able to apply the logic of third monday.For eg: if i run my macro on 20th august. i will check if its 3rd monday and will add one excel sheet with the name as "August 20 2012".Please let me know how this can be achieved.Thanks!Archie

 

[patel45]

attach a link to your file with comments

 

[Rick Rothstein]

See my mini-blog article here..

Nth Such-And-Such Day Of The Month

for both a generalized formula and function which can be called from other VB code or used as a UDF (user defined function) that allows you to calculate what you asked specifically for and more.