Tuesday dates

[john9210]

I'm looking for a formula that calculates the date of the second Tuesday of any month, based on the month number. Any suggestions.

[comment]

A month number is not enough. You also need to specify the year. Then you can do =

Let ( [
firstOfMonth =  Date ( month ; 1 ; year ) ;
diff = 3 - DayofWeek ( firstOfMonth ) ;
firstTuesday = firstOfMonth + Mod ( diff ; 7 ) 
] ;
firstTuesday + 7
)

 

 

[john9210]

Thanks, it works great!