Calendar examples

Ensure you have a calendar that repeats every Monday. Typically, that is the system calendar Mondays@Sys.

Ensure you have a calendar called ‘Holidays’ that defines all of the non-working holidays for your company. Typically, that is the system calendar Holidays@Sys.

From the Calendar menu, select New Calendar, then choose Combine Calendars.

Define a combining expression that specifies ‘mondays’ but not ‘holidays’ as follows:

Mondays@Sys Not in common with Holidays@Sys

Do this by double-clicking on Mondays@Sys, then double-click on Not in common with, and then Holidays@Sys.

Provide a meaningful description for the calendar, and save it with a unique name, such as ‘workingmondays’.

From the Calendar menu, select New Calendar, then choose Specify Pattern.

Click Weekly.

In the Every n weeks field, specify 2.

Ensure The following days is selected, and click FRI, as follows:

Provide a meaningful description for the calendar, and save it with a unique name, such as ‘oddfridays’.

Ensure you have a calendar that defines working days. Typically, that is the system calendar businessdays@Sys.

Create a calendar called last_friday_of_month, similar to the system calendar first_friday_of_month@Sys.

From the Calendar menu, select New Calendar, then choose Combine Calendars.

Define a combining expression that specifies last_friday_of_month and the days it has in common with businessdays@Sys as follows:

last_friday_of_month@user In common with businessdays@Sys

Do this by double-clicking on last_friday_of_month, then double-click on In common with, and then businessdays@Sys.

Provide a meaningful description for the calendar, and save it with a unique name, such as ‘lastworkingfriday’.