Excel Magic Trick 1125

Data Validation Custom Formula: Workday Dates in Current Month

DESCRIPTION

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.

WORKBOOKS

Download “Excel Magic Trick 1121-1140” Excel-Magic-Trick-1121-1140.zip – Downloaded 1 time – 2 MB




Be the first to comment

Leave a Reply