Do not perform on weekend

[DHAM1963]

=OR(WEEKDAY(A3)=1,WEEKDAY(A3)=7)
=IF(ISNA(VLOOKUP(B$1,Drivers!$A$2:$A$26,1,0)),"NA","")

So what I am trying to do is put these together, I only want to perform the second line if A3(column A is a date field) is not a weekend but I am struggling to get it to work properly. Any help would be appreciated. TIA

 

[Joe4]

Welcome to the Board!
You can imbed them in an IF formula, i.e.
=IF(OR(WEEKDAY(A3)=1,WEEKDAY(A3)=7),IF(ISNA(VLOOKUP(B$1,Drivers!$A$2:$A$26,1,0)),"NA",""),"")

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(WEEKDAY(A3,2)>5,"",IF(ISNA(VLOOKUP(B$1,Drivers!$A$2:$A$26,1,0)),"NA",""))

 

[DHAM1963]

Hi & welcome to MrExcel.
How about

=IF(WEEKDAY(A3,2)>5,"",IF(ISNA(VLOOKUP(B$1,Drivers!$A$2:$A$26,1,0)),"NA",""))

Thank you so much, this solution worked well for me. The other thing I had to do to make it all work was to delete all the conditional formatting I had on the sheet, go and apply the formula and then add the conditional formatting back after the formula was in effect, it seemed to understand at that point that the formula goes first and then the conditional formatting.

 

[DHAM1963]

Welcome to the Board!
You can imbed them in an IF formula, i.e.
=IF(OR(WEEKDAY(A3)=1,WEEKDAY(A3)=7),IF(ISNA(VLOOKUP(B$1,Drivers!$A$2:$A$26,1,0)),"NA",""),"")

Thanks for your suggestion!

 

[Joe4]

Thank you so much, this solution worked well for me. The other thing I had to do to make it all work was to delete all the conditional formatting I had on the sheet, go and apply the formula and then add the conditional formatting back after the formula was in effect, it seemed to understand at that point that the formula goes first and then the conditional formatting.

Hmm... That does not sound quite right to me. It does not matter what order formulas on the cell were entered versus when the Conditional Formatting was created.
More likely, there was an issue with the Conditional Formatting rule you had, and it needed to be corrected.