Resting Anchor

The Anchorage

Personal website of Gregory K. Maxey, Commander USN (Retired)

Date Sequencer
(A Microsoft Word Help & Tip page by Gregory K. Maxey)

DISCLAIMER/TERMS OF USE

The information, illustrations and code contained in my "Microsoft Word Tips" are provided free and without risk or obligation.

Click to acces PayPal Verification Service Click to acces PayPal Verification Service

However, the work is mine. If you use it for commercial purposes or benefit from my efforts through income earned or time saved then a donation, however small, will help to ensure the continued availability of this resource.

If you would like to donate, please use the appropriate donate button to access PayPal. Thank you!

Click to donate British Pound Sterling                   Click to donate US dollars                   Click to donate EU euros

The purpose of this Microsoft Word Tips & Microsoft Word Help page is to introduce and publish "Date Sequencer."  Date Sequencer, now with a time span calculator, is intended as a manually loaded Word add-In. It provides a user interface for inserting a current, past, or future date and extended date sequence entries in Word documents.

The time span calculator will display the time span between two anchored date values with a choice of two formats.

You can use "Date Sequencer" to insert the current date, a "picked" date from a custom Date Picker  control, roll up/back (i.e., future or past) dates, and user defined date sequences.

Site Note iconNote: "Date Sequencer" was originally created using Word 2003. In December 2020 the original .dot file format with toolbars was converted to .dotm file format with associated ribbon controls and the original calendar control replaced with a custom Date Picker control.  The original .dot format file is still available in the zipped download file package.  However, as the original calendar control is no longer included in the Windows controls set, it may not function with newer operating systems.  .

User interface with "Date Sequencer" is through an easy to use controls group on the Ribbon Add-Ins tab and a custom userform "Control Panel."

date_sequencer_1

Ribbon Add-In Tab Controls Group and Control Panel

date_sequencer_2

Most features are fully explained using the Help command button controls.  The "Fill Selected Cells" output option can be used to fill a selection of cells in a Word table with a sequenced output. In the examples below, the cells in a selected table row has been filled with the sequenced days of the week and the cells in a selected table column have been filled with a sequence of time entries using a period of minutes and factor x15.

date sequencer 5

date sequencer 6

That's it! I hope you have found this tips page useful and informative.  Download the add-ins here:  Date Sequencer

Site Note icon For more on template add-ins and how to load them, see: Organizing Your Macros/Template Add-ins at: Installing Macros

Share

DISCLAIMER/TERMS OF USE

The information, illustrations and code contained in my "Microsoft Word Tips" are provided free and without risk or obligation.

Click to acces PayPal Verification Service Click to acces PayPal Verification Service

However, the work is mine. If you use it for commercial purposes or benefit from my efforts through income earned or time saved then a donation, however small, will help to ensure the continued availability of this resource.

If you would like to donate, please use the appropriate donate button to access PayPal. Thank you!

Click to donate British Pound Sterling                   Click to donate US dollars                   Click to donate EU euros

Search my site or the web using Google Search Engine

Google Search Logo