Need last workday with Mon's & Tue's off

[Alphonse68]

Hello all,
I have this formula in B1 to find the last workday of the month having Mondays and Tuesdays off:

=WORKDAY.INTL(A1,NETWORKDAYS.INTL(A1,EOMONTH(A1,0),3)-1,3)

which goes down the column to B12, with A1:A12 varying from A1=01/01/2018 to A12=12/01/2018.
It all works well except for Jan, May, and Oct, for which I erroneously get 28, 30, & 28, respectively.
These are the last work dates for each month this year, according to a Wed thru Sun work week:
31 W, 28 W, 31 S, 29 Su, 31 Th, 30 S, 29 Su, 31 F, 30 Su, 31 W, 30 F, 30 Su

Any ideas why it will not do as I'm supposing it should on those three dates?

Cheers,
Alphonse

 

[Tetra201]

Try

=WORKDAY.INTL(EOMONTH(A1,0)+1,-1,3)

 

[Alphonse68]

So much simpler!!
Works like a charm!!
Thanks, Terra201.

 

[Tetra201]

You are most welcome.