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.


Download “Excel Magic Trick 1121-1140” Excel-Magic-Trick-1121-1140.zip – Downloaded 285 times – 2 MB

Be the first to comment

Leave a Reply