Excel Magic Trick 1125

Data Validation Custom Formula: Workday Dates in Current Month


See how to use Data Validation Custom Formula to verify that dates entered into cells are in current month and are NOT a weekend or holiday. See the AND and NETWORKDAYS.INTL functions as well as between date criteria using comparative operators.