method CalendarCombo.AddNonworkingDate (Date as Variant)
Defines one or more non-working dates, either individually or by using a format expression that specifies recurring non-working dates.

TypeDescription
Date as Variant The Date parameter can be one of the following:
  • A Date expression that indicates the date being marked as nonworking day. For instance #12/25/2026#, adds 12/25/2026 as a non-working day
  • A String expression that specifies the repetitive expression that defines the non-working days as Easter, Christmas or Holydays. For instance the "month(value)=7 or ( month(value) = 12 and day(value)=25 )" indicates July and December 25th is a non-working dates. The string version of the AddNonworkingDate supports value formatting. The value keyword indicates the date being queried. If the expression is not syntactically correct the non-working date expression is not added and so represented.

Use the AddNonworkingDate method to define specific dates as non-working days. To mark recurring days within a week (such as every Saturday and Sunday), use the NonworkingDays property. To remove a date previously added with AddNonworkingDate, call RemoveNonworkingDate (it only removes dates added through that method). To clear all custom non-working dates at once, use ClearNonworkingDates.

You can control how non-working days appear using:

Examples of repetitive expressions

The expression syntax supports predefined functions as documented here. In all expressions, the value keyword represents the date being evaluated.