Configure a Special Day

Review Special Day concepts and reference sections.

Toedit or create a Special Day in the General section of the Setup area:

Select a special day and click Edit; or click Add to create a special day.
Name the Special Day.
Configure the new Special Day record by configuring the desired settings in the fields and areas provided. Utilize the dynamic date formulas in the next section as a starting point when defining Special Days.
Click Save.

Dynamic Date Examples:

Christmas Day: 12/25/####
Christmas Eve: 12/24/####
New Year’s Day: 01/01/####
New Year’s Eve: 12/31/####
Columbus Day - 2nd Monday in October: *(10/01/####(0%))Monday(2)
Easter Sunday: *(03/21/####(0%)^(01/09/2001 20:25:00,42524MINUTES,1))SUNDAY(1!)@00:00:00
Independence Day: 07/04/####
Father’s Day - Third Sunday in June: *(06/01/####(0%))SUNDAY(3)
Mother’s Day - Second Sunday in May: *(05/01/####(0%))SUNDAY(2)
Labor Day - First Monday in September: *(09/01/####(0%))MONDAY(1)
Memorial Day - Last Monday in May: *(05/../####(0%))MONDAY
Martin Luther King Day - Third Monday in January: *(01/01/####(0%))MONDAY(3)
President’s Day Third Monday in February: *(02/01/####(0%))MONDAY(3)
Thanksgiving Day - Fourth Thursday in November: *(11/01/####(0%))THURSDAY(4)
Canada Day: 7/01/####
Thanksgiving Day - Second Monday in October (Canada): *(10/01/####(0%))Monday(2)
Boxing Day (Canada): 12/26/####
or *(12/26/####(0%))NEARESTWEEKDAYUse NEARESTWEEKDAY to move the special day to the nearest Monday or Friday if the holiday occurs on a weekend.
Family Day - Third Monday in February (Canada): *(02/01/####(0%))MONDAY(3)
Good Friday - Friday before Easter Sunday (Canada): *(03/21/####(0%)^(01/09/2001 20:25:00,42524MINUTES,1))FRIDAY(1!)@00:00:00
Victoria Day - Monday preceding May 25th (Canada): *(05/../####(0%))MONDAY-1WEEK
Civic Holiday - First Monday in August (Canada): *(08/01/####(0%))MONDAY(1)
Remembrance Day (Canada): 11/11/####

**If the holiday occurs on the weekend, use NEARESTWEEKDAY to move a special day to either the nearest Monday or Friday; for example: *(12/25/####(0%))NEARESTWEEKDAY