Welcome to 2016!!
If you’re like me, you like to use the first few days of the year to do the things you won’t have time to once life returns to its normal hectic pace. One of these items is adding non-working days to your enterprise calendars in project server and project online.
In Australia this task is made somewhat more complex by how we deal with public holidays when they fall on a weekend – sometimes we reschedule them to the next working day and at other times we miss out on a day… Anzac day 2015 was the most memorable example of us missing out on a public holiday.
In my case I wanted to add all the national public holidays for the next five years as efficiently as possible and have made the below notes to help others performing the same action.
Step 1: Open the calendar in MS Project for Editing:
- From Server Settings, Select Enterprise Calendars, select the desired calendar (Standard is the default) and Edit.
Step 2: From MS Project add the following recurring holidays:
- New Year day – set to recur every year on Jan 1st
- Australia day – set to recur every year on Jan 26th
- Anzac day – set to recur every year on April 25th
- Queen’s birth day – set to recur every year on the second Monday in June (for WA & QLD use state specific date)
- Labour day – set to recur every year on the first Monday in October (for WA, NT, VIC & TAS use state specific date)
- Christmas day – set to recur every year on Dec 25th
- Boxing day – set to recur every year on Dec 26th
That has 70% of our non-working time covered, but what about the years where the above dates fall on a weekend?
Step 3: Add the exceptions to the recurring holidays for 2016 – 2020:
- New Year day – Mon, 2 Jan, 2017
- Australia day –
- Mon, 28 Jan, 2019
- Mon, 27 Jan, 2020
- Anzac day – For us the eastern states there are no exceptions…. If it falls on a weekend the public holiday is not rescheduled L.
For other states
- 27th of April 2010
- Christmas day – Mon, 26 dec, 2016
- Boxing day – Tue, 27 dec, 2016
But wait – we have missed Easter! Easter is tricky as the dates change from year to year so we need to add every one individually
Step 4: Add the dates for Easter, and any state based holidays:
- Easter 2016 25th – 28th March
- Easter 2017 14th – 17th of April
- Easter 2018 30th – 2nd of April
- Easter 2019 19th – 22nd of April
- Easter 2020 10th – 13th of April
- Add any state based holidays applicable (eg Family day in the ACT, Melbourne Cup in Vic etc)
- And then close the Enterprise calendar – your changes will be automatically saved
So within less than 30 minutes you have ticked off one of those tasks and you can forget about it now – until next January at least.
However having added the above makes me realise that the MS Project interface to the calendar is not optimised to review a large number of non-working days. What would be nice is a query that can export excel all the current non-working time applied to a certain calendar. The blog I found here looks promising….
I have pasted the table of National non-working days for the next 5 years below for your further information.
|New Year’s Day :||Yrly on Jan 1st||Fri, 1 jan, 16||Sun, 1 jan, 17||Mon, 1 jan, 18||Tue, 1 jan, 19||Wed, 1 jan, 20|
|NYD Exceptions||Mon, 2 jan, 17|
|Australia Day :||Yrly on Jan 26th||Tue, 26 jan, 16||Thu, 26 jan, 17||Fri, 26 jan, 18|
|AD Exceptions||Mon, 28 jan, 19||Mon, 27 jan, 20|
|Good Friday :||NA||Fri, 25 mar, 16||Fri, 14 apr, 17||Fri, 30 mar, 18||Fri, 19 apr, 19||Fri, 10 apr, 20|
|Easter Monday :||NA||Mon, 28 mar, 16||Mon, 17 apr, 17||Mon, 2 apr, 18||Mon, 22 apr, 19||Mon, 13 apr, 20|
|Anzac Day :||Yrly on April 25th||Mon, 25 apr, 16||Tue, 25 apr, 17||Wed, 25 apr, 18||Thu, 25 apr, 19||Sat, 25 apr, 20|
|Queen’s Birthday :||Yrly, 2nd Mon in June||Mon, 13 jun, 16||Mon, 12 jun, 17||Mon, 11 jun, 18||Mon, 10 jun, 19||Mon, 8 jun, 20|
|Labour Day :||Yrly, 1st Mon in October||Mon, 3 oct, 16||Mon, 2 oct, 17||Mon, 1 oct, 18||Mon, 7 oct, 19||Mon, 5 oct, 20|
|Christmas Day :||Yrly on Dec 25th||Sun, 25 dec, 16||Mon, 25 dec, 17||Tue, 25 dec, 18||Wed, 25 dec, 19||Fri, 25 dec, 20|
|Xmas Exceptions||Mon, 26 dec, 16|
|Boxing Day :||Yrly on Dec 26th||Tue, 26 dec, 17||Wed, 26 dec, 18||Thu, 26 dec, 19||Sat, 26 dec, 20|
|BD Exceptions||Tue, 27 dec, 16||Mon, 28 dec, 20|