VBA to get 2nd Tuesday of month

[wotadude]

For current month, return 2nd Tuesday of the month.
If current date is in month = Sep, Dec, Mar or Jun, otherwise return null.

[martindwilson]

do you need vba or will a function do?
function is in cell formated as date

Please Login or Register  to view this content.

a1 can be replaced with today() else enter date in a1

[wotadude]

thats great.
i would like a bit of vba for same if possible.
thanks