It is a common requirement in documents to insert dates that occur a number of days after an initial date. This is covered in some depth in the companion page linked from the column on the right.
To broaden the range of handy add-in functions available from this site, I thought it would be useful to put together an add-in that used the VBA version featured on that page, enhanced to allow for weekends and holidays to be included in the count.
Easter holidays (Roman and Orthodox) and weekends are hard coded into the add-in. Other holidays are user-programmable to account for local and national holidays, by entering the holidays in a pair of tables in the add-in template itself. To access these tables it is necessary to open the template for editing in Word and make the changes.
Variable holidays are those which occur on a particular day of the month, but in which the date itself varies. e.g. The US Holiday 'Thanksgiving' occurs on the 4th Thursday in November. The above table allow such dates to be handled. The table also accepts the word 'Last' (not case sensitive) for the last particular day of the month e.g. The U.S. Memorial Holiday is the last Monday in May.
Where date numbers are incorrectly entered the holiday is ignored.
Fixed holidays are those that occur on the same date each year, for example New Year's Day is always on the 1st January.
The add-in is activated from a button on the Insert tab of the ribbon:
After the usual disclaimer, text the add-in displays a userform from which the basic selections are made. The options should be self explanatory. The initial date is today's date.
Click the Pick Date button and a date picker is presented. Click the date in the calendar to replace the date in the Initial Date box.
All calculations are based on the initial value and the value of the number of days entered to count on (or back) from the initial date value.
Check the 'Exclude Weekends' check box to enable the three options that relate to how weekends are handled.
By default the date is inserted at the current cursor position, but you may prefer to insert the date at a pre-defined bookmark location anywhere in the current document, or replace a bookmarked date with a revised date. By checking the 'Check to insert date at a named bookmark' check box you will be presented with a text box to enter the name of the bookmark in question.
By default the bookmark name 'bmDate' is used, but this can be changed to suit personal preferences and the change stored in the template.
If the named bookmark is missing from the document when this choice is selected, nothing is inserted into the document by the add-in.
Checking the 'Exclude Holidays' check box enables another tabbed page where you may choose options for Easter (Roman and/or Orthodox) which employ algorithms to calculate Easter for any year.. You may also choose to include holidays entered in the tables described at the start of this page.
The calculated dates is inserted at the current cursor position..
This page features an add-in which is loosely based on the code at the end of the companion page 'Insert a date other than today's date' but much enhanced to accommodate holidays and weekends and served up in an accessible format for users uncomfortable with VBA programming.