|re: "1st and 3rd Tuesday of each month"|
Look here for a tip on how to find the 1st Tuesday of each month.
Modify the solution to find the 3rd Tuesday
re: "14th of each month "
Put 1/14/2011 in Excel and use this to get the 14th of every month:
re: "last business day of the month"
I don't see how Excel will know what is the last business day of your business month unless there is some sort of repeatable criteria that defines it. Perhaps we need some more details on that.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.