Excel formula to check Sat, Sunday and Bank Holidays to Return Certain Value

I wrote following formula;

=IF(AND(WEEKDAY(M$1)>1,WEEKDAY(M$1)<7),IF(AND(M$1>=$H2,M$1<=$I2),IFERROR(VLOOKUP(M$1,BH!$A$2:$A$35,""),$D2/$G2),""),"")

What I want to do in attached sheet is, if the date in cell M1 is a weekday (i.e., Monday through Friday) and if it is between the dates in cells H2 and I2. If both of these conditions are met, the function then checks if the date in cell M1 is not equal to any dates within A2:A35 (BH Tab). If it is not equal, the function returns the value in cell D2 divided by the value in cell G2.
If the date in cell M1 is found in the range A2:A35, the function returns an empty string.
Problem I am having is formula returns values for the dates from A2:A35 (BH TAB)
Hope I explained clearly. Any advice please.

Try:

Formula:

Please Login or Register  to view this content.

copied across.

Thanks for the rep.

Assume this resolved your issue?