Review Special Day concepts and reference sections.
To open or create a Special Day:
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/####
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