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

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




Be the first to comment

Leave a Reply