3rd Monday in Month formula help

[bl1nd]

Hey peeps,

I am looking for a dynamic formula that returns the 3rd Monday in February based on a year value.
I am using

Please Login or Register  to view this content.

Where A1= the year value.

This formula works perfectly, except when the 1st of February is on a Monday, then it returns the 4th Monday of the month. What am I doing wrong?

[Phuocam]

Try this

=WORKDAY.INTL(DATE($A$1,2,0),3,"0111111")

[bl1nd]

I don't understand your formula, but it works lol
Thank you!

[Phuocam]

One way

=DATE($A$1,2,22)-WEEKDAY(DATE($A$1,2,1),12)

[bl1nd]

Follow-up question, now need the last Monday preceding May 25 of the given year, but can't figure that one out either.

Please Login or Register  to view this content.

Gives me the day of the week that the 25th falls on, but how do I roll that back to the Monday before?

[Phuocam]

Please Login or Register  to view this content.

[bl1nd]

Thank you!