Formula for IF it's the 2nd or 4th thursday of the month

Originally Posted by Jonmo1

Try

=WORKDAY.INTL(INT(J1)-DAY(J1),2,"1110111")
Change the 2 to 4 to get the 4th thursday.


If you can change J1 to =TODAY() instead of =NOW(), then
=WORKDAY.INTL(J1-DAY(J1),2,"1110111")

Tried this with the =NOW(), but it populates no matter what day I change the computer to:

=IF(WORKDAY.INTL(INT(J1)-DAY(J1),2,"1110111"),Data!C30,"")