Excel Magic Trick 1126

Populate Calendar with “X” Based on Start, End, Weekend & Holiday Dates

DESCRIPTION

See how to complete a monthly employee calendar with the text “Training” based on a start and end date, and holiday and weekend dates. See the functions: IFERROR, WORKDAY.INTL, IF, AND, and NETWORKDAYS.INTL.

WORKBOOKS