What I'm looking for is code for if i enter a date into a cell and this date is either a saturday, sunday or a holiday then checkbox1 is hidden.

Obviously the first part of this is ' Me.CheckBox1.Visible = IIf(Range("$F$6").Value = ' but i can't get the correct code for the last part.

Thanks for any help.