2nd Tuesday of the month

Hi

I wonder if anyone can help me. I am using the following formula to calculate the second Tuesday of the month

=DATE(YEAR(A5),MONTH(A5)+1,14)-WEEKDAY(DATE(YEAR(A5),MONTH(A5)+1,4))

What I am finding is that for May 2019 it is only giving me the first Tuesday of the month.

Why would this be. It seems to be correct for every other month for 2019.

Please Help

Another way:

=WORKDAY.INTL(EOMONTH(A5,0),2,"1011111")

Thank you Phuocam. That works perfectly.

Can a similar thing be used for the last Thursday of the month.

Is there anywhere I can find further info on this?

Thank you Bo_Ry that is really useful and clear

Ah I have just realised if the last Thursday of the month is the last day of the month it gives the previous week date.

for example Thu 28 Feb actually returns the result of Thu 21 Feb

Any ideas

Originally Posted by morglijay

for example Thu 28 Feb actually returns the result of Thu 21 Feb

Adjust a little:

=WORKDAY.INTL(EOMONTH(A5,0)+1,-1,"1110111")